In sqlserver2005, I have a column containing my name and ID number. Some ID numbers have 15 digits, and some have 18 digits. How to separate them?
Create table tbinfo (tbname varchar (20), -name.
Id varchar (20),-ID
)
select * from TB info where len(id card)= 15
select * from TB info where len(id card)= 18