how to increment nchar type number

Question

Plz help me: I have a field serial_number in table tblSerialNo with its type as nchar(10) how can i write an sql query that returns the serial number incremented by one

Jeff B · Answer

Provided it's a true number stored in the field you can: SELECT CAST(serial_number AS INT) + 1 as SerialNumber FROM tblSerialNo; However if serial_number has any non-numeric data in it this will throw an error.