Stuart McLachlan
stuart at lexacorp.com.pg
Mon Aug 9 18:23:18 CDT 2004
On 9 Aug 2004 at 10:24, Arthur Fuller wrote: > > replace([ColumnOfInterest],"-","") > > Substitute the actual column name for [ColumnOfInterest]. Run the query > and you're done. > Sorry Arthur, but it doesn't work like that - you just get an error saying "undefined function replace" That's why I wrote the function myReplace() -- Stuart