On Wed, 09 Jan 2008 11:21:43 +1000, [EMAIL PROTECTED] wrote: >Hello. I've written a UDF named ENCRYPT. I want to do something like this: > > UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName) > >The UDF gets called, but not with my data - rather something like "0.0". Kind >of weird. Does Sqlite handle SQL expressions inside the parentheses? I also >tried this but without success: > > UPDATE Employees SET EncryptedName = ENCRYPT(LastName) + ', ' + >ENCRYPT(FirstName) > >Thx >-brett
I think the + sign forces SQLite into thinking this is a numerical expression ( + ) of which the outcome is zero, because from a numerical viewpoint all the terms have value zero. In other words: The contatenation operator is || , not +. -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
