Friday, March 30, 2012

remove extra characters

I have the following sql statement:

SELECT FTE_CLASS_GROUP_NBR_DSCR
FROM dbo.DLIST_FTE_CLASS_GROUP
WHERE FTE_GRP_ID IS NOT NULL

This is an example of the result returned:

9999/00 Some lenghty text is displayed after the numbers

I want to trim everything after 9999/00

Is there a way to use rtrim to remove the characters after the numbers or another method?

Thanks,
-D-Please disregard...I found the solution. Thanks.

No comments:

Post a Comment