Thanks! I got that to work.

I didn't think of ISNULL and COALESCE.

I'm assuming you used ISNULL because there were only two arguments and is more efficient?

Also, I see...

Thank you everyone, I appreciate all the responses. Obviously I wasn't thinking clearly about what it was I was actually trying to do now. My mind was stuck in what...

Thanks, Pradeep. I was trying to find a way to make something I can run more than once, though. We're still developing and cleansing the underlying data and I know...

karthikeyan (12/12/2008)

---

yes...it should work..

because it should use the ascii value..so ascii value for b is always greater than ascii value of a...so it will show the first part...

but in my...

The query is not pulling by latest insert, it's pulling alphabetically (higher ascii number?), so when you ask it to find > 'karthik', it's probably looking at the ascii equivilant...