Is this what you're looking for ?!?! (run against Pubs database)...

create procedure testProc 
@au_id varchar(15) = NULL
as

if @au_id is NULL
select * from dbo.authors
else
select * from dbo.authors where au_id =...

Maybe you could make a copy of the table - except this time define the column with the default collation and then try to copy the values into this to...

Yes - you don't know that you've been reported missing...but if there's one thing that family could've been (almost) sure of it's just that one fact - that friends and...

Kim found deceased

So that's the end to this story - it seemed like a miracle when the mother and kids were found alive and in good condition - somehow...

Sorry - My example really should've been:

if 'test' = 'test     '

print 'the same'

else

print 'not the same'

Last post I promise....

I set the compatibility level to 60 - "messed around" some and then forgot to reset it back to 80...

I went...

From BOL....

"...setting the compatibility level of a database to 65 makes the database version-6.5 compatible, but does not necessarily provide version 6.5 behaviors. For example, when SET ANSI_PADDING is ON...

So I set the compatibility level to 60, then 65, 70 and 80....when I ran the following script against each setting I got the exact same results....

Select 'Not the same'

Where datalength('test') <> datalength('test     ')

Select 'The Same'

Where len('test') = len('test     ')

hmm...and here's another test where they're treated the same too...maybe michelle should use datalength..

create table #Spaces(col1 varchar(5), col2 varchar(5))

go

insert into #Spaces values('         ', '')

insert...

Steve - please tell us that you were able to identify the culprit and that he/she is now history on this site ?!?!

Also that measures have been taken to prevent...

Sorry - didn't realize that this was a "cleaning operation"....

So it's not just a simple.....

SELECT EmpName, MAX(EmpDateTime)

FROM Employees

GROUP BY EmpName...

I can't hear your thoughts as well as I was able to - combination of various factors not the least of which is that I don't visit this site as...

And how was I supposed to know you already emailed Steve....the crystal ball I use doesn't work that well Remi..