Replace in Select Statement??

Hi ;)

I have a select statement where i need to Replace some Chars
Maybe someone can help

SELECT * FROM reguser WHERE REPLACE(" & whereTable & ",'-',')

I want to Replace the"-" and the"/"

Thanks in advanceIt looks like you are concatenating this string from a .NET app (?). If so, is it possible in your scenario to do the replace before you concatenate the qeury together? If not, you are certainly on the right track with the T-SQL REPLACE function. Here's thedoc on that just in case.|||Hi :)

Thanks for the answer ..
The code like it is ..works and replaces the"-" ...but i just wanna add another replacement for the"/"...but i cant find the right way to do it

Thanks|||did you try this:

SELECT * FROM reguser WHERE REPLACE(REPLACE(" & whereTable & ",'-','') ,'/','')|||Thanks a Lot mate ;)

Thats it!!

Cheers