Hi,
How can I replace a charcter of "column/field" in the table.

I have column in the table called "Ref". I need to relplace the character ":" with NULL or SPACE if the Ref column contain char ":".

For example, if "Ref" column contain value of "abc:xyz", I need to replace ":" with NULL or SPACE. I need to do this from DBaccess or ISQL mode.

I'm looking any funcitons like "REPLACE" which is available in SQL Server.

Appreciate if you could provide any sample or source code to acheive this may be thru a Stored Procedure/routine etc..

Regards,

Function REPLACE(string, replaced_substring, new_substring) exists in IDS too. You can include something like replace( string,':',' ') in your dbaccess statements or in spl.

Iñaki

hi thanks.. great help mate