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 «««23456

Simple LIKE with wildcard Expand / Collapse
Author
Message
Posted Thursday, May 27, 2010 12:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:03 AM
Points: 1,226, Visits: 758
First thought: How can values like 'AA' be found with LIKE '_' ?

Zero rows. Click. Zero points.

Next time I will wait for the caffeine to do its work. I learned something, hope I remember it when I need it.




Dutch Anti-RBAR League
Post #928763
Posted Thursday, May 27, 2010 1:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:43 AM
Points: 1,358, Visits: 1,313
gserdijn (5/27/2010)
First thought: How can values like 'AA' be found with LIKE '_' ?

Zero rows. Click. Zero points.

Next time I will wait for the caffeine to do its work. I learned something, hope I remember it when I need it.

I was surprised too. I watched it after one of my coworkers came with a question: "How it is possible, this query returned this data?" His pattern was little bit more complicated, something like '__[_]_[_][[]%'.
And the best point: I could write a question with "It depends" option




See, understand, learn, try, use efficient
© Dr.Plch
Post #928767
Posted Tuesday, June 1, 2010 8:37 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
I almost picked "It Depends" because, but I thought no, it couldn't be possible with a standard VARCHAR. Learned another thing today, at the cost of a point.
Post #931069
Posted Wednesday, September 22, 2010 6:57 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 11:26 AM
Points: 8,718, Visits: 9,266
A beautiful question, which may have made some of the backwoodsmen notice that there are collations other than the one which fits US ASCII perfectly and fits nothing else. But I'm not holding my breath while waiting for the average US (or should that be "U/S"?) DBA or DB designer to notice our weird "foreign" collation stuff.

Tom
Post #991665
Posted Thursday, September 23, 2010 12:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:43 AM
Points: 1,358, Visits: 1,313
Tom.Thomson (9/22/2010)
A beautiful question, which may have made some of the backwoodsmen notice that there are collations other than the one which fits US ASCII perfectly and fits nothing else. But I'm not holding my breath while waiting for the average US (or should that be "U/S"?) DBA or DB designer to notice our weird "foreign" collation stuff.


Thank you.




See, understand, learn, try, use efficient
© Dr.Plch
Post #991750
Posted Wednesday, March 30, 2011 9:42 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 4:40 PM
Points: 654, Visits: 375
Great question, thanks!
I lost a point here, but it was well worth it as I hadn't even considered collation when I answered.
Post #1086602
Posted Wednesday, June 11, 2014 8:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:37 PM
Points: 2,677, Visits: 215
How did I miss this one?
Post #1579647
Posted Wednesday, June 11, 2014 5:07 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 11:26 AM
Points: 8,718, Visits: 9,266
crussell-931424 (6/11/2014)
How did I miss this one?

Judging by your comment posted Tuesday, May 25, 2010 2:33 PM the answer to that question is pretty obvious, but in the interests of being polite I will omit supplying that answer.


Tom
Post #1579854
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse