Sorry

select cleanstring from dbo.isfn_QBRemoveNonAlphaChars('Abu???////Dina')

Gives back AbuDina so no spaces insrted. 🙁

Jeff, I'm in awe!

Respect my good man!

So we're rebuilding the string one character at a time and keeping only characters (LIKE '[a-z ''-]'). Maybe I'm just stupid but how do...

Hi Lowell,

Just got home to see your reply.

I don't have access to my work right now but your method is just easier to understand and adapt.

Will try again tomorrow and...

Hear hear

Cadavre, my sincerest apologies! :blush:

Cadavre, the ^ at the end is there to exclude the - from being removed.

Adi, I'm happy with your solution!

Thanks to you both.

I don't want the function to remove spaces, single quotes and dashes but I still want it to remove non characters like [, {, #

It's almost working except for the...

Nudge, push, shove whatever it takes as long as...

Matt Miller (#4) (8/9/2012)

---

Abu Dina (8/9/2012)

---

Those in charge have told me that it would take too long...

Point taken. :blush:

4 machines running windows server 2003 so why not just configure a low disk alert using peperformanceogs and alerts.

I deserve a slap for this!!!

A T-SQL...

Those in charge have told me that it would take too long to enable database mail (ISO...

Evil Kraig F (8/8/2012)

---

Abu Dina (8/8/2012)

---

You're spot on once again. I had a meeting with the Director of Software development and she made a point about the data services team...

Once again thanks for your input G² your time is much appreciated.

Please...

This would be a primary load location (or a series of scripts deployed to the database that you've just built via Model) that would take care of all standard...

John Mitchell-245523 (8/8/2012)

I think Michael's idea is the best, if this exercise is really necessary. It's going to involve a lot of manual work. I can't understand why...