Stupid question but why would you want to upgrade if you're going to use 80 compatability ? Surely you lose most of the benefits of the upgrade so why...

Why not use a ddl trigger to populate a table with relevant field names and use that table to build dynamic SQL in the trigger on the insert

Why not just use UNION ALL with each of the dfferent days

INSERT INTO @strDays

SELECT '1'

FROM [dbo].SSS_DOW WITH (NOLOCK)

WHERE SSS_DOWID IN (28,41,44)

and...

I would use UNION ALL - and I also ask the rest of my team to comment anywhere they use UNION - just to make sure they didn't mean to...

Surely you have only a finite number of fields they could use in the where clause so just have parameters for each of those - You are really asking for...

This is really bad - You are allowing anyone to run anything they want - DON'T DO IT !!!!

Sorry but without table structures and some data it would be very difficult to recreate your query

Can you post the table create statement and some dummy data to work...

You're dead right if you prevent duplicates you can only have one null in the table. Is there any other way you could make it unique - how about using...

I was using a delimited string that i was splitting up and then using len to work out how many characters to strip out next time around, but when someone...

You need to watch out for any *= or =* joins in the where clause as this is no longer supported!

Unless of course it's a char field in which case it would just return the length of the field that was declared

Hmm I wonder why IBM are struggling 😀

Glad to be of help:)

Try using nvarchar - this will give you a much bigger character set than varchar

Are you using CHAR fields or NCHAR?