How do I use the RTRIM function in a query to remove white spaces after text and a field.

Thanks in Advance!
Lane

Dim MyVar
MyVar = LTrim(" vbscript " ' MyVar contains "vbscript ".
MyVar = RTrim(" vbscript " ' MyVar contains " vbscript".
MyVar = Trim(" vbscript " ' MyVar contains "vbscript".

Download the VBScript Documantation:
msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001169

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thanks,
How would I do this in an SQL query?

Thanks,
Lane

Could you explain a bit more about exactly what you are trying to achieve, are you collecting values from a form etc?

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo