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 @ 7:43 PM
Points: 33,046, Visits: 15,152
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: Wednesday, July 16, 2014 8:55 PM
Points: 1,668, Visits: 739
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: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
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: Sunday, June 29, 2014 11:26 PM
Points: 1,481, Visits: 1,960
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:26 AM
Points: 3,849, Visits: 4,986
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, July 18, 2014 6:09 AM
Points: 532, Visits: 447
Good question. Thanks Steve.
Post #1516407
Posted Thursday, November 21, 2013 7:19 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 1,823, Visits: 1,356
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.




Everything is awesome!
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: Yesterday @ 3:30 PM
Points: 4,379, Visits: 3,390
Nice and easy. Thanks, Steve!
Post #1516498
Posted Thursday, November 21, 2013 10:12 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, June 30, 2014 10:51 PM
Points: 754, Visits: 145
Nice question....
Post #1516642
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse