exec xp_msver

..or...now that you're all rested and back with renewed vigour from the vacation - you could go to "resources" - "columnists" - where under each group, the columnists are listed...

happy to help! the reason for my second post was to explicitly display which was 'previous' and which 'next'...

rg - i had forgotten about this even though it has been addressed in quite a few posts...this is why you're the rg and i'm just brain-dead!

you could do something like this:

SELECT IDENTITY(INT,1,1) AS Row_Number, *
INTO #Results
FROM tblMytable
WHERE ....
 

SELECT *
FROM #Results
ORDER BY Row_Number

Ryan - I'll take a stab at it - though things are often clear inside my own head I may lose something in the translation...

SELECT Position = 'Previous', seqID = MAX(ID) FROM myTbl WHERE seqID  145 AND STATUS BETWEEN 1 AND 3
ORDER BY 1 DESC

making a mental note to myself never to...

joejoe..another method - again, as gilamonster says - won't work if the characters are anywhere embedded in your string...

select colname from tbl where

cast(substring(colname, 2, len(colname) - 1) as integer) >...

if the characters A & B are in the beginning or the end....

if in the beginning, you could do -

select colName from tbl where colName like 'A%' or colName...

you could try doing something like this:

SELECT PreviousID = MAX(ID) FROM myTbl WHERE seqID  145 AND STATUS BETWEEN 1 AND 3

sorry ranga - but I really wish you'd picked any example but this...formatting and display have nothing to do with logic and rules...(imo)!

ryan - completely misunderstood your question - thought you wanted to update 3 different rows (as opposed to 3 columns in a single row) - only became clear when you...

would you pl. do me a favour and post the data from each of your tables ?!?!

i ran a quick test on some "dummy" tables and i did get 3...

you know SLFine...things are difficult enough when we do this in English...why don't we just leave other languages out till we've got at least one mastered ?!?!

ryan - did you try it with the syntax i sent you - substituting x.cat with x.value of course...you should get 3 updates with that one statement...???