Tara-1044200
SSCoach
Points: 15951
More actions
June 5, 2009 at 12:25 pm
#155790
How can i find records longer than 9 digits.
I have a char field of 10 but most of the numbers are 9 digits, how would i found if there are any 10 digit number.
nary
SSCrazy
Points: 2869
June 5, 2009 at 12:37 pm
#1005487
Use Len() function .
like select * from tablename where len(ltrim(rtrim(cloumnname))) >9
HWH..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply