replacing a character in SQL

[lasd]

Hi

I was hoping someone could help me. I have written some SQL code to extract data from some tables. The data has been extracted but then i want to copy this data to a different file. The problem is that one of the fields(path field) contains some characters that i do not want. for eg. 2D#201!.TIF. i do not want to see the hash here. i want to remove and delete the hash from the original file name when i am copying it over to the new file. Is this possible and do I need an if-then-else statement.... here is the code i wrote to copy over the file

select 'Copy ' || profile.docserver_loc || profile.path || TRIM(components.path)
|| ' ' || TRIM(components.path)

it is on the second TRIM(components.path) that i need to delete the hash in the file name.
thanks a million in advance for the help.
lasd

 

[Golom]

You could try

select 'Copy ' || profile.docserver_loc || profile.path || TRIM(components.path) 
               || ' ' || [COLOR=red]Replace([/color]TRIM(components.path)[COLOR=red],"#","")[/color]

 

[PHV]

... || REPLACE(TRIM(components.path), '#', '')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886