I know that but this query results in a scan :

Declare @name as varchar(10)

set @Name = 'id'

Select * from dbo.SysColumns where name like @Name + '%'

Nice point... but I'm still not totally sure of what he wants to do.

null = null returns unknown (without returning false, it doesn't return true). So there's just no match found in that query.

well this would do it in this case.. but what are you trying to achieve exactly?

set @MyMin = ISNULL((Select min(Number) from dbo.Fruits), 0)

I can't replicate that index seek here..

Can you post the ddl and some sample data so I can understand what I'm doing wrong?

I was just prooving your point.. you can't have duplicate values on the clustered index...

Hey Frank, do you have a link where I can learn to show more smiley faces than the one I already way too overused (

wow.. thanx for the trick, really gonna be usefull one of these days.

I could post it but it would be in french so I'll pass on this occasion, but I created this little script.

create table #a

(

A int not null

)

GO

Insert into #a (a)...

Yup... we sometimes have huge threads and we have no other choice than to have 'em on difference pages. Also helps to see the sponsors more (hey they got...

Try something like this in the datasource of the textbox :

=DateDiff("h";[StartDate];[EndDate])

then at the bottom of the report you should be able to use sum([txtboxname])

This would look something like this :

Select * from dbo.YourTable where YourCol = '123456f' collate LATIN1_GENERAL_CS_AC

You mean smalldatetime?

Yup that does it.

It's not that hard to do for the time part... but I wouldn't want to code the functions to handle the date part :

Declare @ms as int

Set @ms =...