Salvatore - busy morning so can't test this right now - but it appears that what you noticed about QPP and your omission of it is the problem - it...

this is untested but i think should work...

update tblMyTable

set col1 = replace(col1, '_', '')

where (PATINDEX('_', col1) > 1)

oops - just realized you said ACCESS - maybe you could use ascii...

Nope - no noeld - but now that you have the union thing going with him remi you can pm him and ask...

meanwhile - for Ian - here's the...

sure we can ask noeld (not that there's anything wrong with that) - but wasn't he on the other post that had the exact same question...????

will go and check!

Here's something that I just tested:

I created a linked server on my machine :

exec sp_addlinkedserver @server = 'TestLinkServer',

...

here's the link to another post (kinda) similar in concept...

database design

maybe they're testing people to see if they still remember the answer...

Glad you posted this - I've been seeing this since afternoon and just thought that I'd finally outstayed my welcome on ssc.com...

I've been...

'swatisaid....in my second para....mayhaps you need some caffeine mike ?!?!

Salvatore - it appears that you ran farrell's query against the temp tables that we had created for testing and not against your actual tables....his query should work as you...

pzmrcd - what you're talking about is changing the "order by" from - say firstname to lastname....

eg: if you had "Select firstname,lastname,age,dob,addr from Person order by firstname"

- you could change...

why would i be sucking up remi ?!?! besides he may not be GOD but he most certainly is a demigod! (at least a sql server demigod!!!)

noel - what's wrong...

just make sure you give me enough notice noel - so i can roll out the red carpet...wouldn't like you walking around on dusty ground like ordinary mortals when you're...

LOL....

Great! I'm sure when steve, andy and brian started this site they never thought they would be offering competition to e-harmony!

remi - may i...

noel - put remi out of his misery and say "yes" - tho' I'm not sure why he should be "husband"....."not that there's anything wrong with that...!" (remi - I'm...