okay remi...now that we've gotten all the funny stories out of the way...do you feel like looking at some really lousy t-sql that i have to write to make this...

select isnumeric(right('camel 1', 1))

select isnumeric(left(reverse('camel 1'), 1))...

these seem to work fine...didn't test with variables though...

I think you'll have to search the posts - this topic has been often discussed...I too use VSS and agree that it's hard to manage unless you're really really disciplined...

cspangler...go look at this other post....the problem seems to be similar except i don't have the time to follow through and verify...

other post

Hey mike...wouldn't mind being a mirror image of remi's brain... - otherwise - not that i have anything against him - but thanks but...

could you have duplicates ?!

camel 1

camel 1

camel 1.........???

does the description field always end in numbers ?

is it always 1 and 2 or could they go up to any number ?

Why are you trying to do this exactly...long story...legacy database..have to take rows from one table and update columns in another...will probably be back with some more stupid "how to"...

hmm - so if it's 1 ID then min and max would both be the same right ?!

maybe i don't need the Select @ID1 = -1, @ID2 = -1 defaults...

on T-SQL - I need help with getting some IDs....

LOL...thank you for helping out remi...now would you pl. get your a%$ to my post on this forum and give me the "magic" solution ?!?!

I respect his knowledge.......noel - this is going to make you blush again so don't read it....

he may have all the knowledge in the world remi - but there are...

I wouldn't like to see you suffering that much...

that's kind of you noel...but why die an agonisingly painful death...if it is to be complete annihilation then might as well not...

remi - you can deny it till you turn blue in the face but i think i know you fairly well enough by now to say that i don't think...

alors noel! your wish is my command!

I shall try and arrange for my disappearance sooner than planned!

ps:I am definitely going to miss all of you and the nonsensical exchanges...

It IS going to happen!!!...tener paciencia...quiero mas tiempo...(????) - my spanish is very rusty!