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 @ 5:12 PM
Points: 32,394, Visits: 16,704
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, September 2, 2015 6:39 PM
Points: 1,817, Visits: 822
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: Yesterday @ 8:09 AM
Points: 14,615, Visits: 12,682
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 SQLKover.

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

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, February 17, 2015 6:07 AM
Points: 1,526, Visits: 2,000
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, July 10, 2015 9:26 AM
Points: 616, Visits: 279
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 5:53 AM
Points: 4,609, Visits: 6,165
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: Tuesday, September 1, 2015 2:54 PM
Points: 533, Visits: 457
Good question. Thanks Steve.
Post #1516407
Posted Thursday, November 21, 2013 7:19 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 28, 2015 7:31 AM
Points: 2,182, Visits: 1,620
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: Tuesday, September 1, 2015 1:12 PM
Points: 4,698, Visits: 3,906
Nice and easy. Thanks, Steve!
Post #1516498
Posted Thursday, November 21, 2013 10:12 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 14, 2015 4:45 AM
Points: 1,186, Visits: 174
Nice question....
Post #1516642
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse