how to remove a white space in vb6.0

[progvar]

Hi
i have not any idea how to remove white space in vb
actualy i am accessing value from table some time the column is null and some time it contain space means user press space bar to remove data from that field
when i access value null field executes but the field which contain white space
please give some idea how i can remove executes data in both conditions
or how i will remove white space

thanks
veer

[debasisdas]

thanks
veer

i am going to ban both of your account if you don't stop posting alternately from both of your ids.

[jamesd0142]

does vb6 have the ltrim() or rtrim() functions?