IBM DB2 ODBC DRIVER

through the ODBC Data Source Administrator.

I don't know what DirectAccess is?

Also....it only seems to want to restart after those instances which had SP3a, we have one instance that did not have any service packs, just the base install, and that...

I thought so, but wanted to check anyway.

thanks for your help!

Thanks again.  You put me on the right track!

For those that are interested, I found the answer:

SELECT DISTINCT(column_name) COLLATE (collation_name)

FROM .....

Thanks for your reply.

But I don't actually want to permanently change the collation sequence of the column...is there any way I can convert the data to case sensitive through my...

thanks very much, this helps.

I tried the CONVERT function, and it didn't seem to work...

Thanks Jeff, your last suggestion, this works great.

thanks for all your suggestions.  As we have over 30 people in the domain admin group, I feel I need to remove them....there are only a few in the DBA...

Thanks for your replies.

After more investigation, I think the problem has something to do with the null indicator, because if I populate the SQL Server table with a value in...