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 @ 2:04 PM
Points: 31,797, Visits: 16,277
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: Sunday, February 22, 2015 10:31 PM
Points: 1,813, Visits: 803
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 @ 9:05 AM
Points: 14,265, Visits: 12,258
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
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
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:18 AM
Points: 4,384, Visits: 5,786
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: Wednesday, December 31, 2014 9:45 AM
Points: 533, Visits: 450
Good question. Thanks Steve.
Post #1516407
Posted Thursday, November 21, 2013 7:19 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:11 AM
Points: 2,106, Visits: 1,567
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: 2 days ago @ 9:55 AM
Points: 4,384, Visits: 3,592
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: Wednesday, March 18, 2015 4:24 AM
Points: 1,060, Visits: 168
Nice question....
Post #1516642
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse