SQLServerCentral » Latest topics
Trim off trailing letters
Hi all,
I need to trim off whichever letters are at the end of a reference number.
Example: If the reference number is ABC/12345A or ABC/12345ABBBBC or ABC/12345WRBV , it should be left with only ABC/12345.
Thank you in advance!
I need to trim off whichever letters are at the end of a reference number.
Example: If the reference number is ABC/12345A or ABC/12345ABBBBC or ABC/12345WRBV , it should be left with only ABC/12345.
Thank you in advance!
No comments:
Post a Comment