Forgot to hit the upload button.

I ran

select * from IDCARD where try_cast( barcode_comp as int ) is null;

and still get

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value...

sorry I meant to delete that once I added the txt file.

I'm trying to add the formula in column properties 12345 ' ', idnumber

I get this error saving

'IDCARD' table

- Unable to modify table.

Incorrect syntax near ' '.

any help is...

what if my id is 9 digits? and the code is 5 digits? 12345 999999999

Trying create a column with leading code 12345 along with id number. 12345 999999999.

Thanks, I'm trying this now. :-):-)

Thanks:-):-):-):-):-):-)! Much appreciated!