My wrst IT job was working for a boss, who by his own admissions had 'black periods', and was a total control freak.

For example, he sent around a memo to...

How about something like this?

CREATE TABLE Player

(PlayerID INT IDENTITY(1,1) PRIMARY KEY

,FirstName VARCHAR(50)

,LastName VARCHAR(50)

,PlaceOfBirth VARCHAR(50))

GO

CREATE TABLE GeneralManager

(ManagerID INT IDENTITY(1,1) PRIMARY KEY

,FirstName VARCHAR(50)

,LastName VARCHAR(50)

,TeamID INT)

GO

CREATE TABLE Team

(TeamID INT...

Thanks for all of your replies. They made me laugh, even if they only confirmed what I already knew!!:D

thanks for all of the replies.

No, the developer is not still around. He is about 4 developers ago!! But I believe he was a c programmer!!

The code is to...

Thanks for the reply.

On closer inspection, they are not straightforward or, ands and nots. The main query has this:

WHERE ( dbo.vuln_Or( dbo.vuln_And( dbo.vuln_And( T0.T337, T0.T302 ),

T0.T589 ),

dbo.vuln_Or( dbo.vuln_And(...

Brilliant! Many thanks to you both for your help!!

Hello,

thanks for all your advice.

Yes, we work in a case sensitive environement (sigh!)

Using LIKE without a wildcard, doesn't that just make it the same as '=' when comparing...

thank for your reply John,

I which case I think I need the bracket as I want:

SELECT ID

FROM dbo.qryTest

WHERE UPPER(Name) = UPPER('Jim')

AND

( UPPER(Addr1) LIKE UPPER('London')

or...

DOH! Many thanks!