G
Guest
How do I seperate the following in a sql query:
Field1: 123456789-JohnDoe
into
Field2: 123456789
Field3: JohnDoe
Here's the formula I use in access query, but I want to use them in a sql
pass-through query.
Field2: Left([Field1],InStr(1,[Field1],"-")-1)
Field3:
Mid([Field1],InStr(1,[Field1],"-")+1,(Len([Field1])-InStr(1,[Field1],"-"))+1)
Thanks a bunch!!
Field1: 123456789-JohnDoe
into
Field2: 123456789
Field3: JohnDoe
Here's the formula I use in access query, but I want to use them in a sql
pass-through query.
Field2: Left([Field1],InStr(1,[Field1],"-")-1)
Field3:
Mid([Field1],InStr(1,[Field1],"-")+1,(Len([Field1])-InStr(1,[Field1],"-"))+1)
Thanks a bunch!!