converting null value-failure

[manoranjan_d]

Hi all,

In my backend data base i have null value example below

Backend Data:
Low_USD

NULL

55.49

0.00

100.45

Now in my script i have given 3 types of try but its not working  to covert this null value

if(Low_USD=Null() or Low_USD='NULL',0.00,Low_USD) AS [Low_USD]

as per condition it shd show 0.00 but its showing 0 only

i also tested with character also

if(Low_USD=Null() or Low_USD='NULL','A',Low_USD) AS [Low_USD],

again its showing as 0 only not the A

even i tried the thrid one also

if(isnull(Low_USD) or Low_USD='NULL' or Low_USD=' ' ,'0.00',Low_USD) as [Low_USD]

its not showing the value as 0.00 its showing only 0 only

these are being tested in the list box value

le tme know how to cinvert this?

[sunny_talwar]

May be try this

If(Len(Trim(PurgeChar(Low_USD, Chr(160)))) = 0, '0.00', Low_USD) as Low_USD

[Or]

If(Isnull(Low_USD),'A',Low_USD)

Null = Null evaluates to false (null does not equal null).

If your column is numeric, you can also use Len(Low_USD) = 0. If it's text, an empty string would be a problem in that case.

[pradosh_thakur]

hi

try using fucntion isnull()

it returns -1 if value is null or else zero

so your expression would be

if(isnull(Low_USD) = -1 or upper(Low_USD)='NULL' or Low_USD=' ' ,'0.00',Low_USD) as [Low_USD]

check the format of the column in the number of the chart you are using.

regards

Pradosh