Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Wildcards Expand / Collapse
Author
Message
Posted Wednesday, November 20, 2013 10:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:20 PM
Points: 32,764, Visits: 14,928
Comments posted to this topic are about the item Wildcards






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1516317
Posted Thursday, November 21, 2013 12:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:10 AM
Points: 1,565, Visits: 689
Nice straight forward question. Thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1516333
Posted Thursday, November 21, 2013 12:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:46 AM
Points: 12,176, Visits: 9,128
Easy one. Thanks Steve.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1516336
Posted Thursday, November 21, 2013 5:56 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, November 21, 2013 11:33 PM
Points: 1,481, Visits: 1,959
To nitpick.

For '[]' to be valid as an answer SQL should have allowed something like
mychar LIKE '[]dam' 

But this offcourse doesnt work. '[]' only work in conjunction with other input. In this case 'a-z'... which offcourse means that if one of the examples had started with a "1" for instance... it would not have been found. Also some international characters wouldnt have worked with 'a-z' either.

Whereas '_' works as is.

/T
Post #1516387
Posted Thursday, November 21, 2013 6:24 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 20, 2014 6:00 AM
Points: 588, Visits: 276
Good question. Man, I have not used the "_" in a while so I almost got it wrong. Thankfully my brain kicked in.

Thanks for the question.
Post #1516398
Posted Thursday, November 21, 2013 6:26 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 4:15 AM
Points: 3,681, Visits: 4,815
Nice simple one, thanks Steve.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1516402
Posted Thursday, November 21, 2013 6:39 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 11, 2014 11:55 AM
Points: 507, Visits: 415
Good question. Thanks Steve.
Post #1516407
Posted Thursday, November 21, 2013 7:19 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:09 AM
Points: 1,712, Visits: 1,244
steve.jacobs (11/21/2013)
Good question. Man, I have not used the "_" in a while so I almost got it wrong. Thankfully my brain kicked in.

Thanks for the question.

+1 Same here. I really had dive deep into the memory banks on this one.




Yeah, uh huh, you know what it is. Everything I do, I do it big

Post #1516426
Posted Thursday, November 21, 2013 10:02 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 8:10 AM
Points: 4,231, Visits: 3,315
Nice and easy. Thanks, Steve!
Post #1516498
Posted Thursday, November 21, 2013 10:12 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 4:54 AM
Points: 638, Visits: 134
Nice question....
Post #1516642
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse