UPDATE statment
Posted: Fri Apr 23, 2010 1:48 pm
I am trying to update a new field with a field named 'filename' but only want the left charactors (length of what it is -4)
I am a newbi! Please help
UPDATE photographs SET basefilename = substr(filename,0,lengh(filename)-4)
I am a newbi! Please help
UPDATE photographs SET basefilename = substr(filename,0,lengh(filename)-4)