Re: [sqlite] Problems with the UPDATE command

Regards Rodney > To: sqlite-users@sqlite.org > From: itandet...@mvps.org > Date: Thu, 5 Nov 2009 14:42:30 -0500 > Subject: Re: [sqlite] Problems with the UPDATE command > > Rodney Cocker <rodneycoc...@hotmail.com> > wrote: > > I ran

[sqlite] Problems with the UPDATE command

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