J Justin Mar 13, 2008 #1 I have text data in my table formated 11-11-11. I want to change the "-" to ":" so the result will be 11:11:11.
I have text data in my table formated 11-11-11. I want to change the "-" to ":" so the result will be 11:11:11.
F fredg Mar 13, 2008 #2 I have text data in my table formated 11-11-11. I want to change the "-" to ":" so the result will be 11:11:11. Click to expand... Update YourTable Set YourTable.[FieldName] = Replace([FieldName],"-",":")
I have text data in my table formated 11-11-11. I want to change the "-" to ":" so the result will be 11:11:11. Click to expand... Update YourTable Set YourTable.[FieldName] = Replace([FieldName],"-",":")
J John W. Vinson Mar 13, 2008 #3 I have text data in my table formated 11-11-11. I want to change the "-" to ":" so the result will be 11:11:11. Click to expand... UPDATE tablename SET fieldname = Replace([fieldname], "-", ":") WHERE fieldname LIKE "*-*-*";
I have text data in my table formated 11-11-11. I want to change the "-" to ":" so the result will be 11:11:11. Click to expand... UPDATE tablename SET fieldname = Replace([fieldname], "-", ":") WHERE fieldname LIKE "*-*-*";
