My vbscript reference says the right way to check
for a null field is:
isNull ( mystring )
so why doesn't this work?
if ( IsNull( sList ) ) then
'do nothing
else
Re...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_10297656.htm...
Zones:
ASPDate Answered: 02/21/2000 Grade: B Views: 6
Hi,
I need to update a column (+1) for all entry matching in a list.
UPDATE table
SET err = isNull(0,err) + 1
WHERE custno in (@list)
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20442341.html
I am trying to use a ISNULL function in a mathematical statement. How can I get this working?
In SQL I use
ISNULL(({Field1}),0) - ISNULL(({Field2}),0) * ISNULL(({Field3}),0)
So how could I ...
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_20521153.html
Hi
This may be very basic question - but can I use isnull while creating a view
e.g is this ok.
SELECT
(isnull(B.field1,0)/B.field2) NET,
FROM
TABLE1
...
http://www.experts-exchange.com/Database/Oracle/Q_20556470.html
Zones:
OracleDate Answered: 03/19/2003 Grade: A Views: 0
I have a library database with a field for author's last name and another for first name. I am trying to design an "author search" query for the library. The first and last name for the search ar...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20596429.html
Zones:
MS AccessDate Answered: 04/25/2003 Grade: A Views: 0
for a table temp
which have a column is named id varchar(20)
in select clause
select 1
from temp t
where isnull((select id from temp where t.id= id and 1=2 ), '2') = '2'
will reutrn n...
http://www.experts-exchange.com/Database/Sybase/Q_20751412.html
Zones:
SybaseDate Answered: 07/11/2004 Grade: A Views: 0
in vb6 there was IsNull()... is there a replacement in vb.net?
- Marc
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20813419.html
Zones:
Visual BasicDate Answered: 12/01/2003 Grade: A Views: 252
Hello,
Here's the problem. if this (If Form2.SetAlertsViewer.ListItems(H).ListSubItems(1) = "Source Interface" Then) isn't true SourceIntCol collection never gets built and this (If SourceIntCol...
http://www.experts-exchange.com/Programming/Misc/Q_20954410.html
Zones:
ProgrammingDate Answered: 04/14/2004 Grade: A Views: 102
dear experts,
Below is a set of SQL. I need to update the value of col1=0, i tried the isnull function to accomplish this, obviously i am missing something. help greatly appreciated
than...
http://www.experts-exchange.com/Database/Sybase/Q_21192556.html
Zones:
SybaseDate Answered: 11/03/2004 Grade: A Views: 4
I have a problem...I have the following code to display inventory values for groups in a web page. i am able to display the information if the value is either null or greater than 0....but i get a...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21378506.htm...
Zones:
ASPDate Answered: 04/11/2005 Grade: B Views: 0
