This is SQL Server 2005... with that in mind, you don't need the overhead of UDF's and you sure as heck don't need a cursor or While loop for such...

Thanks for the feedback, Judy.

It seems to happen every February... company finally gets a new budget for the year, hires some folks in January, and they start asking questions in February. It's compounded...

Thank you, Anirban. You're always gracious and kind with your words.

They republish this article about every two months or so to try and help folks with their...

Judy, are you all set with this?

Like Gail said, that's probably why...

kbatta (2/9/2009)

---

One problem I run into with these articles is only one inch of the code is visible at a time. Is there a way I can get more...

In that case, this might be just a little faster because it doesn't have as many CONVERT's...

SELECT CONVERT(CHAR(11),GETDATE(),101)

+ CONVERT(CHAR( 5),GETDATE(),114)

You could always use a view.

Bruce W Cassidy (2/9/2009)

---

[font="Verdana"]You can also persist the calculated column, in which case it will only be calculated the once. Bits are good choices for persistance, since they take...

No... when you use any function on the column, the best that will happen is an INDEX SCAN which can actually be worse than a table scan if every row...

What is it that you really want to do? Do you just want to return a list of items that can't be converted to an INT or do you...

BWAA-HAA!!! That's the perfect answer! Thanks for the feedback, Olga! 😀

Garadin (2/8/2009)

---

I hate to use...

andrewd.smith (2/8/2009)

---

Who can say if I'm right other than the OP, it depends on the OP's precise requirements.

OP does state the following which Jeff's query doesn't do.

I also want to...