Thanks for that.
I looked there, but overlooked it.
RBS
> RB Smissaert <[EMAIL PROTECTED]>
> wrote:
>> Where could I find documentation about coalesce?
>
> http://sqlite.org/lang_expr.html
>
> Near the bottom where all the built-in functions are described.
>
> Igor Tandetnik
>
>
Andre du Plessis <[EMAIL PROTECTED]> wrote:
The Id piece works great thanks! If I want to update 2 fields on table
A, the following syntax doesn't work as expected, as it updates all to
records to 'DONE'.
update A set Flag = 'DONE',
Id = coalesce(
(select Id from B
where A.Field1 = B.Fi
RB Smissaert <[EMAIL PROTECTED]>
wrote:
Where could I find documentation about coalesce?
http://sqlite.org/lang_expr.html
Near the bottom where all the built-in functions are described.
Igor Tandetnik
-
To unsubscri
3 matches
Mail list logo
