Very Computer

I'm trying to remove commas from a text in a select
statement.  It looks like this:

Account               Description

626900              Travel, Meals, & Entertainment    

How do I select the description field so the data returned
looks like this:

Travel Meals & Entertainment

Thanks,
Dean

select account, replace(Description, ',', '') as Description...

Quote:> I'm trying to remove commas from a text in a select
> statement.  It looks like this:

> Account               Description

> 626900              Travel, Meals, & Entertainment

> How do I select the description field so the data returned
> looks like this:

> Travel Meals & Entertainment

> Thanks,
> Dean

Trey,

Thanks...that did it...I knew this had to be easy!

Dean

Quote:> select account, replace(Description, ',', '') as Description...

Hmmm, based on the subject, I wouldn't have thought this was valid, since
REPLACE() can't be performed directly on a TEXT column.  I guess I was
assuming "text field" = TEXT column ... however the OP is exchanging TEXT
and VARCHAR freely.

if i'd been more observant, i guess i would have thought the same, but i
only read as far as "remove commas"  before i saw the example data and
figured it couldn't be a text column, but was just "text" <s>

OP?

Quote:> > select account, replace(Description, ',', '') as Description...

> Hmmm, based on the subject, I wouldn't have thought this was valid, since
> REPLACE() can't be performed directly on a TEXT column.  I guess I was
> assuming "text field" = TEXT column ... however the OP is exchanging TEXT
> and VARCHAR freely.