He's a Jedi master wannabe?

Hey Lynn... somebody is impersonating you 😉

http://www.sqlservercentral.com/Forums/Topic672323-1291-1.aspx

It's a system object. Check the Master database.

use master

select so.name,sc.text

from syscomments sc

join sysobjects so on so.id = sc.id

where text like '%syscon%'

and name like 'syscon%'

If your first three parameters are simply the on/off values and the fourth parameter is the actual search string then

where

...

You're welcome. Good luck 🙂

In olden days, when the pictures...

I'll echo Bruce. If you must check all four variables for nulls, there is no getting around just doing it. But maybe if you'll tell us...

There must be something you aren't showing us. There is no subquery shown in your example. The update statement you show will run without an...

Anybody for another "Queen" sing-a-long?

Yes, I remember that article. I'm old school, in that I think trust is something that has to be earned. It shouldn't be a default. ...

Here is how you can quickly strip the time off the date in SQL. In your query, just replace @date with your column name.

--------------------------------------------------

declare @date datetime

set @date =...

It may be that they know it's...

Saints may not beat the snot out of the unbelievers but ancient Jedi Masters do....

The above quote comes from this thread in the newbies forum.

http://www.sqlservercentral.com/Forums/Topic670743-1291-1.aspx#bm671705

Gail, weren't you the person who observed that GROUP...

My pleasure. Good luck.