Thanks very much
A
ac011
@ac011
Posts
-
SQL Server 2008 - Number Manipulation -
SQL Server 2008 - Number ManipulationHi All, I'm very new to SQL Server 2008, and need a bit of help manipulating numbers. I've got a int column holding numbers up to 11 digits. I need to do the following manipulation and use it in a SQL query. Basically, the first digit is transfered to the 3rd position on the right side. 12345678 23456178 or 1234 2134 The values are variable, there are even records with only a value of 1. Thanks in advance.