Getting the String (from the end)

[RemingtonSteel]

What is the string function in SQL if I want to start getting the string from the end.

For example:

Intended Result

Hamilton, ON, CAN -> CAN
Regina, SK, CAN -> CAN

Thanks!
Gene

 

[Mike Lewis]

Gene,

Could you be more specific. Do you want to get the last three characters? Or the last word? Or the string after the last comma? Or what?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[mmerlinn]

[ ]

Maybe something like:

[tt]
originalstring = "Hamilton, ON, CAN"
resultingstring = ATXRIGHT(originalstring, ', ')
[/tt]

See faq184-5975 for the code for the ATXRIGHT UDF.

mmerlinn

http://mmerlinn.com

"We've found by experience that people who are careless and sloppy writers are usually also careless and sloppy at thinking and coding. Answering questions for careless and sloppy thinkers is not rewarding." - Eric Steven Raymond

 

[Stella740pl]

I would suggest something as simple as

string1="Hamilton, ON, CAN"
string2=ALLTRIM(RIGHT(st1,LEN(st1)-RAT(",",st1)))
?st2

but you said, "in SQL"? Do you mean SQL Server or you just meant VFP's own SELECT-SQL?

 

[Stella740pl]

...and of course, I meant string1 wherever I put st1