Thanks Rechard and Gerry for the quick reply. I will use that alternative
solution.
Is there any easy way to get the size of data stored in a table, size of a
row usig Sqlite C APIs?
Venkat.
On 2/26/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"venkat akella" <[EMAIL PROTECTED]> wrote:
venkat akella wrote:
lenght() function in SQL Query is not behaving properly. I have
explained this below with an example.
Select length(col1) + length(col2) + length(col3) + length(col4) from
TestTable;
For example, there are four columns in a table and in a row three
columns (col1,
"venkat akella" <[EMAIL PROTECTED]> wrote:
> Hi
>
> lenght() function in SQL Query is not behaving properly. I have
> explained this below with an example.
>
>Select length(col1) + length(col2) + length(col3) + length(col4) from
> TestTable;
>
> For example, there are four columns i
venkat akella wrote:
even if one column is NULL, then its effecting the whole query.
If you want NULL treated as zero numerically for col4, use
coalesce(col4,0). Or you could find a way to get 0 into the column
rather than NULL before the expression is evaluated.
HTH,
Gerry
-
4 matches
Mail list logo
