Wildcard

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Prakriti Agrawal » Wildcard

18 posts, Page 1 of 2

1 2 »»

Wildcard

Rate Topic

Display Mode

Topic Options

Author

Message

agrawal.prakriti

Posted Monday, January 25, 2010 9:35 PM

SSC-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

GlenParker

Posted Tuesday, January 26, 2010 1:22 AM

Right there with Babe

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:56 AM
Points: 751, Visits: 129

Never seen this wildcard till now, thanks for the tip, was worth getting it wrong

Glen Parker Smile

Post #853435

sjimmo

Posted Tuesday, January 26, 2010 6:18 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:51 AM
Points: 2,862, Visits: 2,465

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

Dave62

Posted Tuesday, January 26, 2010 6:35 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 9:03 AM
Points: 1,497, Visits: 1,508

That's what I get for answering before having my coffee. Doze

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

Nice question.

Dave

Post #853578

John McC

Posted Tuesday, January 26, 2010 7:34 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 21, 2013 6:30 AM
Points: 562, Visits: 1,404

DOH missed Jim at the top...

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. Crazy

Post #853638

Cliff Jones

Posted Tuesday, January 26, 2010 7:38 AM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:11 PM
Points: 3,390, Visits: 3,403

Thanks for the question! I did not know you could do that (but apparently I am in the minority). Hehe

Post #853647

SanjayAttray

Posted Tuesday, January 26, 2010 8:14 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

Good one. Always used '%' as wild card.

SQL DBA.

Post #853686

Tom Garth

Posted Tuesday, January 26, 2010 9:19 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 04, 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

SQLRNNR

Posted Tuesday, January 26, 2010 12:37 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

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 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #853895

SQLRNNR

Posted Tuesday, January 26, 2010 12:38 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

Thanks for the question and the reminder on this type of pattern matching.

Post #853896

« Prev Topic | Next Topic »

18 posts, Page 1 of 2

1 2 »»

Permissions