Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
NULL and empty string? |
Thu, Jul 12 2012 12:01 AM | Permanent Link |
IQA | Hi I know there's heaps of questions on NULL already, but is there an
easy way to TEST if a field is NULL or an empty string (i.e they did have data in the field but deleted it and leaving the field as an empty string as oppose to a NULL. I'm trying to write a query and wondered if there's a way to test this without saying IS NULL OR field = "" Thanks, Phil. |
Thu, Jul 12 2012 12:21 AM | Permanent Link |
Raul Team Elevate | Try
COALESCE(Field,'')='' Raul On 7/12/2012 12:01 AM, Phil wrote: > Hi I know there's heaps of questions on NULL already, but is there an > easy way to TEST if a field is NULL or an empty string (i.e they did > have data in the field but deleted it and leaving the field as an empty > string as oppose to a NULL. > > I'm trying to write a query and wondered if there's a way to test this > without saying IS NULL OR field = "" > > Thanks, > > Phil. |
Thu, Jul 12 2012 12:57 AM | Permanent Link |
IQA | Ahhh thanks Raul! Awesome.
COALESCE(Field,'')='' |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |