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]
-----------------------------------------------------------------------------
