Simple SQL Replace Command Help

[rwsjbs]

Thanks for looking!

I'm using SQL 2008 Express and need to update a field GCNumber. I'm trying to delete the ; and ? characters so that I'm left with a number.

So the existing string of:
;100335?
Is replaced with:
100335

I know this is very simple, but I'm not able to figure it out.

Please let me know if you can send me a simple SQL statement that would Replace or Trim those characters out.

Thank you,
Richard Scott

 

[gmmastros]

You'll need to run the replace twice, once for each character. You can nest replaces, like this:

Select [blue]Replace([/blue][red]Replace([green]GCNumber[/green], '?', '')[/red][blue], ';', '')[/blue]

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom