query

hi
i have some models that end with +SP e.g. 1234+SP, abcd+SP I want to remove
only the +SP from these models. May i know how can i do it. Thank you
On Fri, 2 Dec 2005 01:38:03 -0800, Tiffany wrote:

>hi
>i have some models that end with +SP e.g. 1234+SP, abcd+SP I want to remove
>only the +SP from these models. May i know how can i do it. Thank you
Hi Tiffany,
If you mean that the +SP is part of the data in your table and
you want to show the data without the +SP, then use
SELECT CASE
WHEN YourColumn LIKE '%+SP'
THEN LEFT(YourColumn, LEN(YourColumn - 3))
ELSE YourColumn
END
FROM ...
If that's not what you want, then please check out www.aspfaq.com/5006,
an excellent description of what information you need to provide if you
want to help us help you.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)