Re: query
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 01 Dec 2005 22:48:10 +0100
On Wed, 30 Nov 2005 18:35:02 -0800, Tiffany wrote:
>Hi,
>
>I have some models that have hyhen in between. e.g.1200LD-VCD, abc-1234
>
>May I know how to remove the hyhen.
>
>Thank you
>
Hi Tiffany,
If you mean that the hyphen is embedded in the data in your table and
you want to show the data without the hyphen, then use
SELECT REPLACE(YourColumn, '-', '')
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)
.
