[quoted text, click to view]

Hi Tiffany,

I'm not sure what "script" you tried, since I posted only a partial
suggestion that you have to complete yourself. For further
trouble-shooting, I can only repeat what I wrote in my original reply:

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.

[quoted text, click to view]

How do you want to handle these? If you want to remove all hyphens, then
stick with the REPLACE I suggested. If you want to remove only some of
them, then you'll first have to explain me how to decide which hyphens
should go and which should stay. I can then try to translate your
requirements into SQL.

Best, Hugo
--

[quoted text, click to view]

Hi Tiffany,

Did you already check www.aspfaq.com/5006, as I requested you two times
before? That article clearly describes the THREE elements I need to be
able to help you.

First: DDL, or CREATE TABLE statement.
Second: Sample data, in the form of INSERT statements.
Third: Desired results.

Here's an example of how you should build your next post. You can copy
and paste the SQL below into Query Analyzer and execute to see that the
results of this query are as I expect them: without hyphens. Now please
post ssome SQL that I can run on my end to reproduce your problem.
Without that, I'm unable to help you further.

-- Create a table for testing
CREATE TABLE ctv_stage
(model varchar(100) NOT NULL)
go
-- Put some sample data in it
INSERT INTO ctv_stage (model)
SELECT '1200LD-VCD'
UNION ALL
SELECT 'abc-1234'
UNION ALL
SELECT 'abc-ded-123-dvd'
UNION ALL
SELECT 'No hyphens here'
go
-- Check test data
SELECT model FROM ctv_stage
-- Test the query
SELECT REPLACE(model, '-', '') FROM ctv_stage
go
-- Clean up my test DB
DROP TABLE ctv_stage

This is the output I got when running the scribt above:

model
------------------
1200LD-VCD
abc-1234
abc-ded-123-dvd
No hyphens here


------------------
1200LDVCD
abc1234
abcded123dvd
No hyphens here



Best, Hugo
--