Rob Schripsema (3/30/2010)
Great idea, Bhuvnesh, but that won't work when there are no Roman numerals at the end.JOHN JONES will end up as John JONES.
But you could use your idea to strip off that last 'word' from the end of a name and match it against a table or list of possible values ('I','II','III','IV','V','VI', etc) and only leave it intact if it matches.
yes i had same doubt but couldnt think as u did. i am gree with you that we can do some lookup table comparision for ROMAN values.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)