Dmitry Teslenko wrote:
>> richardh=> SELECT * FROM chartbl WHERE c LIKE '111';
>> c
>> ---
>> (0 rows)
>>
>> richardh=> SELECT * FROM chartbl WHERE c LIKE '111 ';
>> c
>> ------------
>> 111
>> (1 row)
>>
>> richardh=> SELECT * FROM chartbl WHERE c LIKE '111%';
>> c
>> ------------
>> 111
>> (1 row)
>>
>
> '111%' would also match '1111' and '111anything', wouldn't it?
Yes.
I'm guessing what you actually want is varchar(10) rather than char(10)
as a type.
--
Richard Huxton
Archonet Ltd