Kigtek Solutions

November 5, 2016 | Company News

We are very happy to be working with Kigtek Solutions, a leading Systems Integrator and Electrical Installation Services company based in the central belt of Scotland

ISBN13 to ISBN10 Converter for SQL Server

October 24, 2014 | Blog Technical Solutions

ISBN13 -> ISBN10 Here’s a handy function for converting a 13-digit ISBN to its 10-digit equivalent in SQL Server T-SQL. CREATE FUNCTION TO_ISBN10 ( @isbn varchar(13) ) RETURNS VARCHAR(10) AS BEGIN DECLARE @isbn10 varchar(10); DECLARE @forwards int; DECLARE @backwards int; DECLARE @check int; DECLARE @thisval int; SET @isbn10 =substring(@isbn,4,9); SET @forwards = 1; SET @backwards […]

Photos from the London Book Fair

April 9, 2014 | Company News

Maria visited the London Book Fair on Tuesday this week. Buzzing with activity and enthusiasm, it’s great to see our thriving book industry in action. Lots of familiar faces too, and chocolate frogs!