MS SQL isnull equivalent

Thread View: borland.public.interbase.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Mike Evteev Wed, 27 Nov 2002 18:44

#11328

Author: Mike Evteev
Date: Wed, 27 Nov 2002 18:44

5 lines
949 bytes

Hi all!

What is subj in IB?

Mike

Re: MS SQL isnull equivalent

#11331

Author: Arno Brinkman
Date: Wed, 27 Nov 2002 19:29

27 lines
1316 bytes

Hi Mike,

> Hi all!
>
> What is subj in IB?
>
> Mike

There isn't a equivalent in Interbase.
But there are workarounds with UNIONS or UDFs.

SELECT
  <select_list>
FROM
  ATable
WHERE
  AField IS NULL
UNION
SELECT
  <select_list>
FROM
  ATable
WHERE
  AField IS NOT NULL

Regards,
Arno Brinkman

Re: MS SQL isnull equivalent

#11333

Author: Craig Stuntz TeamB
Date: Wed, 27 Nov 2002 19:55

26 lines
1602 bytes

In article <3de51bfc$1@newsgroups.borland.com>, "Arno Brinkman" 
<bnewsgroups @ abvisie.nl> says...
> SELECT
>   <select_list>
> FROM
>   ATable
> WHERE
>   AField IS NULL
> UNION
> SELECT
>   <select_list>
> FROM
>   ATable
> WHERE
>   AField IS NOT NULL
> 
	I recommend using UNION ALL here instead of UNION -- it's much 
faster.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads