[EMAIL PROTECTED] wrote:
I want to do something like ...
SELECT date FROM tblDate REPLACE (date,'\','-')
but that doesn't work .....
Some of the records have \ and I want -
Any ideas. I can't use cf as the database is in Crystal Reports and I just
need to update the data for a report. (Another hat I sometimes wear)
So you need to adjust the format in the report rather than in the data. I haven't use crystal in about oh.... 6 years, so I've no idea how you would go about doing this now.
Stephen PS I hope those aren't really the column names. ;)
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
