Plz Help

[squrel]

Hello everyone..
I have a table called TxPoHdr and in tht i have a column Contact.... in this column i have lots of names with Mr. and Ms. in the begining of the name... the problem is i have to remove The Mr. and Ms. and just keep the name... but there are lots of records and i can not remove it one by one... Is there any syntax or anything else for this particular problem?
Thank u

[deepuv04]

Hello everyone..
I have a table called TxPoHdr and in tht i have a column Contact.... in this column i have lots of names with Mr. and Ms. in the begining of the name... the problem is i have to remove The Mr. and Ms. and just keep the name... but there are lots of records and i can not remove it one by one... Is there any syntax or anything else for this particular problem?
Thank u

use the following query

UPDATE TxPoHdr
SET Contact = replace(Contact ,'Mr.','')

use the same query to remove 'Ms' and other

thanks

[squrel]

Got it... Thank you very much