Replace function in SQL Expression

[Flopper]

Greetings,

Having a problem attempting to create a SQL expression using the Replace function. I need to use the replace function as a SQL Expression for use in the Selection Criteria.

I'm accessing an Oracle v8 database with Native Connection (pdsora7.dll), and with Crystal 8.5.

I'm attempting to replace "\" with a string of "/". (I need to use a like statement on this string but according to BO Support such a statement will not work on "\"). Therefore i was attempting to use the following syntax but without any luck:

REPLACE("OLE_ITEMS"."OLE_FILENAME","\","/")

I realise that the Replace function within SQL Expressions has only one optional argument but i'm unsure how to obtain the result otherwise.

Thanks

 

[rosemaryl]

Dear Flopper,

I believe that the issue is your double quotes around the text strings instead of single quotes.

Shouldn't the format of the statement be:

REPLACE("OLE_ITEMS"."OLE_FILENAME",'\','/')

hth,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762