Updating a certain part of a string field

[jdougher2434]

Hello,

I am needing to update a string field, by inserting another string in place of a place holder withing the original string, with a sql statement

So for example:

The string I want to update looks like this

SP-CAL WHITES #'XXX',CUT

I want to replace the 'XXX' with 'ABC' when another field in the table is updated with 'ABC'

 

[crystalkiwibruce]

Use the replace function:

Replace({Table.field}, "XXX', "ABC") should work fine.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm

 

[crystalkiwibruce]

Sorry - typed that wrong... Should be

Replace({Table.field}, "XXX", "ABC")

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm