When & where possible, I prefer to replace the pesky quote ASCII code CHAR(39),

with CHAR(146) or CHAR(145) and put an end to the madness of chasing and reacting

to...

I was told yesterday by my MS SQL rep on an incident report I'm working through that I should NOT use the /3gb switch in the boot.ini of 2003 Server EE with...

Yes, plus one was supposed to be there! My apologies, for some unknown reason I do not see a plus sign in the reply preview window; and I was...

A minor refinement of noeld's excellent second suggestion:

SELECT

q1a, q1b, q1c, q1d

, q2a, q2b, q2c, q2d

FROM mytable

WHERE

CASE

WHEN ( q1a + q1b + q1c + q1d ) / 4...

I'm unclear what database system you're using or why

you'd use a non-numeric datatype, but something like

this would work using SQL Server. HTH.

SELECT

CASE WHEN mx =...

Check http://www.sqlmag.com/forums/messageview.cfm?catid=29&threadid=21309

HTH: http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp

You might enjoy trying this too:

DECLARE @missingLink varchar(1600)

SELECT @missingLink = coalesce( @missingLink, ' ' ) + '

INSERT @tbl ( lnkservername, productdata )( SELECT * FROM OPENQUERY( ' + srvname

+...