Skip to Content
0
Apr 29, 2014 at 01:19 PM

Select where clause char comparison

1074 Views

Hello

i have a doubt about a select statement , i have a ZTABLE with a key field char length 11 and a record in the table with the key '00012345678'

i have a field in the selection screen of length 20 which i use for capture the value for find the data in the ZTABLE work fine so far but

if fill the field with the value '00012345678000' ( add 3 more zero at the end ) the record is still find in the DB and my question is this OK ? is this the normal behavior ? or is because is a CHAR type field ?


Thanks