select from 6 characters until the end... 1

[hokky]

Hi guys,

As title above, I need to select from 6th character until the end, how do I do that ?

for example :

input               output

albertman           man
happyforever        orever

thanks guys

 

[r937]

substring(string,7,length(string)-6)

r937.com | rudy.ca

 

[ESquared]

substring(string,7,8000)

I wonder if this method is any faster or slower...

rudy caught the 6/7 discrepancy too...

 

[r937]

substring(string,7,8000) will not work if it's a VARCHAR(MAX) column which has a value longer than 8006 bytes

;-)

r937.com | rudy.ca

 

[ESquared]

yes one would have to be careful with that

substring(string,7, 2147483647)

 

[davidgr144]

How about simply:

right(string, len(string)-5)

 

[ESquared]

That works, too.

Still wondering about the comparative speed of the substring method I suggested.

 

[EzLogic]

you don't have to specify the end.

?substr(alltrim(lcString),7)


Ali Koumaiha
Wireless Toyz
Farmington Hills, Michigan

 

[r937]

ali, which dbms are you using?

in Microsoft SQL Server, there is no "alltrim" function, and substr requires 3 arguments

r937.com | rudy.ca

 

[HarleyQuinn]

I'm going to hazard a guess at FoxPro?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.