Re: query

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)
.