I usually spend an inordinate amount of time mulling over names...I totally agree with keeping it simple, short and descriptive - however, it's not always easy to combine all three...

Why not take the easy way out and do it client-side ?!

marge,

There're several ways to use search to get best results - my "most preferred" is to use the "search" button on the toolbar on top...this takes you to a page where you...

If it is, it should be "thrown up" in the ascii loop....

I'm sure everyone has their personal favourite - maybe you can just pick the one that makes the "most listed"...

mine is "professional sql server 2k programming" - a wrox publication...

maybe changing the datatype to nvarchar and retesting for matches...?!?!

ps:think you've got keywords mixed up...it's "johnny come lately" you must be thinking about!

Intriguing..

You must've done this already and am curious about the outcome...

1) execute sp in QA with "problem" names.

2) change sp to do a "select * from installer_NWD where installer_name =...

hmm - I was going to suggest checking the length as well...wonder what your audit sp looks like...

have you tried manually entering the names that don't find a match ?!...

You're the most irreverent person I know so I'll nab "irrelevant"...always wise to stick to the things you know/do best eh..

Have never worked with Access but here're a couple of things you could check (if not done so already)...

1) Is your database case sensitive ?! If so, you could use...

Whenever I need a break from the tedium of routine I come to this site...and it never fails to pique my interest...I too honed in on "tame of monkeys" and...

What exactly do you want to do....there're a couple of functions that could be used - STUFF(), SPACE(), REPLICATE()...etc..

oh - for good t-sql books - don't know if O'Reilly still publishes them but they used to have a very good one called "Transact SQL Programming"....and then there's Ken...

If you use Query Analyzer to run your t-sql and set the "Default Results Target" under "Tools" - "Options" - "Results" tab as "Results to file", you can save the...

Here's a post that discusses how to backup over a network!