How do I strip first 2 characters ....

[its_me48]

Hello:

I have a name column and all I want to do is if the first 2 characters in the name start with "SN", I need to strip the first 2 characters and load the name.
I can say something like this...
If LEN(link.NAME_COLUMN, 2) = "SN" Then ..???? not sure how to strip
Else link.NAME_COLUMN.

Please help.

Thanks!!

[chulett]

Use the substring operator to check the first two characters. Basically:

Code: Select all

If link.NAME_COLUMN[1,2] = "SN" 

Combine that with the length check to get everything but the first two if that's what you need:

Code: Select all

link.NAME_COLUMN[3,Len(link.NAME_COLUMN)-2]

Of course, some sanity checks on the total size first may be in order.

[its_me48]

Thanks Craig. Works now...

[ray.wurlod]

You may prefer the Left() and Right() functions, as being more meaningful to future developers.