>>Hi everybody,
>>
>>I have two grids on the form. The main table BldMstr sets relation into Lender table

set rela to left(lname,1) into lender

>>
>>If LName is NULL, I have the error, and my relation doesn't work anymore. What should I do?
>
>I guess you van use NVL function to convert null
>
>

set rela to left(<b>NVL(lname, "?")</b>,1) into lender

>assuming that you dont have lender names beginning with "?"


Hi Sergey,

I finally decided to go this route, instead of my code (I may change my mind again in a future :)). I used set rela to left(nvl(lName,OldValue),1) and it suits my needs just fine. Thanks for reminding about nval function.