![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
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 ![]() | 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 Thursday, July 10, 2025 at 10:36 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |