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!!

Accepted Solutions (1)

Accepted Solutions (1)

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

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Husky,

Try This...


Select substring('110100624-5',1,9)

Thanks

Shafi