I am trying to replace a , with a ',' (single quote comma single quote)
For example: 10/18/2006,11/15/2006 to be 10/18/2006','11/15/2006
I have tried the following:
NOTE: New_Date contains the 10/18/2006,11/15/2006
<CFSET New_DATE = #Replace(New_Date, ",", "','", "All")#>
The "','" is a Double quote followed by single quote then a comma the a
single quote then a double quote.
Thanks in Advance.


|