|
View previous topic :: View next topic
|
| Author |
Message |
vikeau
New User
Joined: 07 Jul 2011
Posts: 2
Location: india
|
|
|
|
I want to write a query where we can put NULL in WHERE clause in SPUFI but not sure of how to put it in SPUFI.
Please help to resolve the query.
Thanks in advance. |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
why do you think SPUFI has a different SQL syntax than any other method of invoking SQL?
the only thing different from imbedded sql and 'dynamic sql' as you have in spufi,
is that you can not have host variables in spufi. |
|
| Back to top |
|
|
Naish
New User
Joined: 07 Dec 2006
Posts: 82
Location: UK
|
|
|
|
You mean this, right:
| Code: |
SELECT * FROM TABLE
WHERE <COL-A> IS NULL |
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
What happens when you execute it?
Much faster to try it than wait for us to reply. . . |
|
| Back to top |
|
|
|
|
