1
Reply

In SQL Server -i want the logic

Vijayabhaskar Dabbara

Vijayabhaskar Dabbara

Aug 31 2014 7:43 AM
682
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  ? 

Answers (1)
Next Recommended Forum