V4MD - <null> results with lingo

[Bart Pietercil]

I think that should be

SELECT coalesce(fld_text,"")

but read for yourself

<http://databases.aspfaq.com/database/coalesce-vs-isnull-sql.html>


Nice suggestion Ruslan, it looks like the vacation is paying off :-)  
(I want some)

BArt

On 16-jul-07, at 16:33, Ruslan Zasukhin wrote:

> On 16/7/07 4:46 PM, "Giacomo Vernoni" <giacomo at way-out.it> wrote:
>
> Hi Giacomo,
>
>> Is there a way to get an empty string from an empty or null field?
>
> Something like this:
>
>     SELECT ifnull( fldText, "" )
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina