cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Parsing Numbers

Former Member
0 Kudos

Hi Experts,

I need to return just the first nine numbers of this string '110100624-5'....any examples would be appreciated!!

View Entire Topic
Former Member
0 Kudos

Hi,

Suppose your field name is: Field1 in Table1. You only need them in strings.

Try:

SELECT Left(Field1,9) From Table1

Thanks

Gordon