Yet another method (without having to keep track of escaped quotes)

select foo from bar where charindex(char(39), foo) > 0

/Kenneth

From BOL:

All functions are deterministic or nondeterministic:

Deterministic functions always return the same result any time they are called with a specific set of input values.

Nondeterministic functions may return different...

One of the simplest ways to merge files is by DOS copy. If it's desired to run by Transact SQL, it can be done through xp_cmdshell, though this type of...

The resolved errormessage must be trapped at the calling side (eg client). Some errors are not possible to trap within a stored procedure.

All errors are sent to the caller,...

If you tried a basic select, it most surely did return it's result to the calling client.

So, if the asp page invokes a proc or whatever, and that in return...

crap! Now my lengthy answer just vanished when pressing 'post reply'.. AGH!

Oh, well... Anyway, it was some thoughts about what a move from...

Well, both variants use subquerys

In any case, it's not very easy to maintain this type of 'pivot' queries - they tend to be...

Just some thoughts....

There is no black or white / right or wrong / true or false when it comes to indices / strategy / performance etc... It's all a balance...

I would also suggest the sp solution - it's brings better security among other things.

This isn't a scope_identity problem more than a 'dynamic SQL vs context' problem. Don't use dynamic...

Before you decide upon preferring using dynamic SQL, I recommend you (and everyone else) to read this article about the curse and blessings of dynamic SQL

In short, it is because these are two entirely different questions asked

Just a note, for equi-joins (inner joins) it doesn't matter if the...

I assume this conversion thing is a one-time only deal? (if not, you definetly do NOT want to parse this junk in Transact SQL every time)

Just to add to the mix, I found some notes on determining age in one of the darker corners of my drive...

September 8, 2004 at 12:11 am