String Compare Problem

[bont]

I have a string compare problem. I am basically doing this:

MyVar = ""

.... Pulling SQL Data (from MS Access)
MyVar = SQLField (Data field is NULL)

if MyVar = &quot;&quot; then <-- Doesn't work

if len(MyVar) = 0 <--- Doesn't work

if &quot;X&quot; & MyVar = &quot;X&quot; <-- Works

Any Ideas how I can get one of the first 2 to work?

 

[tsuji]

Hello bont,

Those are little tricks people use to convert variable type away from null. You can use properly IsNull(), IsEmpty() to your situation, such as:

If IsNull(MyVal) or IsEmpty(MyVal) Then
    'do something
End IF

regards - tsuji

 

[bont]

Thanks, this works great. It is silly that it is needed.

 

[rodpettit]

If it's not implicit that a Var is a string, then you will get the problems you describe.

In this case you can use...
myVar = new String (originalVar)