Hello folks.

Which is the right syntax to right this sql in VB6 to pass to CR8, using 
Oracle 8i and DB backend?

Dim UserOffice As String

SELECT TR_USR_IDN_CD, UI_LNAME, UI_FNAME, TR_USR_RNK_ID, TR_USR_RM_NUM, 
FROM TR_SYSTEM_USERS 
WHERE UserOffice = '" & Trim(cboOffices.Text) & "'
 ORDER BY UI_LNAME


'cboOffices' being the dbcombobox.

Thanks.