Skip to Content
0
Former Member
Nov 27, 2006 at 06:58 PM

Trimming Field/String Length

297 Views

Hi:

I an SQL statement in which I have a where clause in which I am comparing/matching 2 fields. I get the error message "...the fields *A and B* must have the same length and type". I know that the types are same but how do I reduce the length of field A to match field B. Field A is 18 characters and field B is 40 chars. Thanks in advance.

B