Hi,

I would like remove or replace characters within a query...
Here is an example what I mean:

select distinct field from table

where results from select are:
28237-F
28237 F
28237F

I want to delete '-' and ' ' characters from field, and result must be
one single row like '28237F'.

Is there any "replace" udf function or any method to replace or delete
characters from string?

Thanks.
Yartax.