Rodney Cocker <rodneycoc...@hotmail.com> wrote: > I ran the following SQL command > > UPDATE local_episodes > SET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename, > 3,LENGTH(EpisodeFilename)) > WHERE SUBSTR(EpisodeFilename,1,3)='F:\' > > Which worked perfectly, but when I went to run it the next time to > change any files stored on my H: drive it didn't work.
Define "didn't work". What statement did you run, and how did the outcome differ from your expectations? How do you run the statement? Be careful with that backslash - many programming languages and shell environments treat those as escape characters (SQLlite itself doesn't). Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
