question on the predicate "like"

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

question on the predicate "like"

Author

Topic

mjfoster65
Starting Member

1 Post

Posted - 2010-11-24 : 15:32:09

What is the function or meaning of the exclamation point ('!') in the following statement?

where Var_A like '!00%'

MJ Foster

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-24 : 16:03:34

Nothing, it's just an exclamation point. The special wilcard characters are %, _ (underscore), [], and

.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2010-11-25 : 05:22:53

It could be a simple typo

-----------

I used to think I wasn't a morning person but it never got better in the afternoon

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-25 : 14:07:07

Just noticed my last wildcard character got converted to an emoticon. It should say [ ^ ] without the spaces.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-11-26 : 02:31:22

quote:
Originally posted by mjfoster65

What is the function or meaning of the exclamation point ('!') in the following statement?

where Var_A like '!00%'

MJ Foster

It is a part of data

Madhivanan

Failing to plan is Planning to fail

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-11-26 : 04:25:02

Looks like Maddy's going for the "post a comment on every thread ploy"
Just thought I'd join in.
Can we have a button to copy a post to multiple threads?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-27 : 12:10:50

Lol

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-11-29 : 04:41:37

quote:
Originally posted by nigelrivett

Looks like Maddy's going for the "post a comment on every thread ploy"
Just thought I'd join in.
Can we have a button to copy a post to multiple threads?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

CTRL+C and CTRL+V would work well

What happened to your old id?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources