In SQL Server -i want the logic
Hi Expert,
In my file one column is like
Id
A9874672
c6784647
h9778334
....
this way
8-lenght fixed data
first character is: A-Z,a-zonly
other 7 chracters are integers:0-9
i want to load this kind of data only to avoid all Irrespective data, how can it possible
Substring(id,0,1)=A-Z,a-z
Substring(id,2,8)=0-9
How to write this expression.............give me solution ?