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 12»»

Wildcard Expand / Collapse
Author
Message
Posted Monday, January 25, 2010 9:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 1:31 PM
Points: 132, Visits: 101
Comments posted to this topic are about the item Wildcard
Post #853411
Posted Tuesday, January 26, 2010 1:22 AM
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: Saturday, March 29, 2014 11:41 AM
Points: 753, Visits: 133
Never seen this wildcard till now, thanks for the tip, was worth getting it wrong

Glen Parker
Post #853435
Posted Tuesday, January 26, 2010 6:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:32 AM
Points: 2,917, Visits: 2,528
I too had to guess. Got it right only because I new the others were wrong. Never saw this wild card before, and look forward to using it.

Thanks for the QOD


Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #853565
Posted Tuesday, January 26, 2010 6:35 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:38 AM
Points: 2,104, Visits: 2,113
That's what I get for answering before having my coffee.

I picked '%im' because of course % is a wildcard. But it will return more than just Kim or Tim.

Nice question.

Dave
Post #853578
Posted Tuesday, January 26, 2010 7:34 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, September 18, 2014 5:45 AM
Points: 568, Visits: 1,603
DOH missed Jim at the top...

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible.
Post #853638
Posted Tuesday, January 26, 2010 7:38 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: Thursday, October 16, 2014 11:48 AM
Points: 3,958, Visits: 3,644
Thanks for the question! I did not know you could do that (but apparently I am in the minority).
Post #853647
Posted Tuesday, January 26, 2010 8:14 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: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Good one. Always used '%' as wild card.

SQL DBA.
Post #853686
Posted Tuesday, January 26, 2010 9:19 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
That's really cool to know.

Thanks for a good QOD.


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #853742
Posted Tuesday, January 26, 2010 12:37 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:24 PM
Points: 17,812, Visits: 15,737
John McC (1/26/2010)
DOH missed Jim at the top...


I nearly did the same thing - had to reread the list of names. If you see Jim at the top, I think the question becomes a lot easier.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #853895
Posted Tuesday, January 26, 2010 12:38 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:24 PM
Points: 17,812, Visits: 15,737
Thanks for the question and the reminder on this type of pattern matching.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #853896
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse