If I have a numeric field that is '99999999999', is there any way to just
update the forth number, something like this although I know it does not
work....
UPDATE blah SET SubString(Switch, 4,1) = '1' WHERE blah
I need to do this to several records and will not know the entire value of
the Field prior to updating. I know I can do this thru a loop but it gets
really ugly when your dealing with several thousands of records.
Thanks,Adrian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
