How to get rid of the spaces in the string

[sabavno]

Hi

I have list populated with the names. When I run sql to find a row, I can't match the value entered in the parameter with the value in the list box.

Here is what happens.

I let the user to enter the name into the input box. User enters "McKay", then I look for "McKay" in my listbox. But McKay value in the list box has spaces appended(E.g. "McKay &quot So I can't locate the row.

Can I get rid of spaces or what else could I do to solve this problem

Thanks

 

[EvilCabal]

Use the trim function : Trim$(str). This will remove any leading and trailing spaces.

 

[sabavno]

Thanks a lot!!! It helped