DSXchange

Hi All,


I have used the Alpha function and handled NULL but it yet does not work and gives warning

If Trim(Lnk_Read_ds.NAME_LINE)='' Or IsNull(Lnk_Read_ds.NAME_LINE) Then 0 Else If Alpha(Trim(Trim(Trim(Lnk_Read_ds.NAME_LINE),'-','A'),' ','A')[2,39]) Then 1 Else 0

Error is "Null String Argument"

Any help

Thanks

I think the problem is to do with:
Trim will not take kindly to a null value as input

try this:

Thanks its working now.