Thanks guys. That did exactly what I wanted!
Igor Tandetnik wrote: > > rockdawg <[EMAIL PROTECTED]> wrote: >> Here are some entries: >> >> smb://MSHOME;kevin:@Movie-server/D/Gladiator/VIDEO_TS >> smb://MSHOME;kevin:@Movie-server/D/Rocky/VIDEO_TS >> smb://MSHOME;kevin:@Movie-server/E/Saw/VIDEO_TS >> smb://MSHOME;kevin:@Movie-server/F/Analyze This/VIDEO_TS >> >> Therefore, I need to insert the string >> "Movies/" between the strings "/D/" and "/Rocky/" (for example) in >> the db so it reads like this: >> >> smb://MSHOME;kevin:@Movie-server/D/Movies/Rocky/VIDEO_TS >> >> I have tried this command: >> >> REPLACE(smb://MSHOME;kevin:@Movie-server/D/Rocky/VIDEO_TS,'D/','D/Movies/') >> >> But i get an error message. What is the proper syntax for the REPLACE >> command in my situation? > > There ain't no such thing as REPLACE command. You need something like > this: > > update paths set strPaths= > substr(strPaths,1,35) || 'Movies/' || > substr(strPaths,36,length(strPaths)-35); > > Igor Tandetnik > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/REPLACE-command-usage-tf2171147.html#a6013543 Sent from the SQLite forum at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------