Click to See Complete Forum and Search --> : Comparing strings in ACCESS


Manfred Staiger
May 29th, 2001, 07:27 AM
Comparing the two strings "LS+" and "LS-" in a ACCESS database return different result. When using the strComp-operation in VBA code "LS-" comes first. When using an ACCESS-query to compare the strings "LS+" comes first. Can anybody tell me how i can accieve the same result with the query and the VBA code ???