RE: Where clause in query

["Mamading Ceesay" <mceesay@xxxxxxxxxxxxxxxxxxxxxxx>]

Jim, Yigal,

You were both on the money!

As Yigal said

> 
> This sounds so familiar...
> Does your CREATE TABLE script happen to define the town column as a 
> CHAR(n) instead of VARCHAR(n)?
> 

Yup, here's the relevant line from the script:

	TOWN            CHAR(10)     NOT NULL,

> 
> If you define a column as type CHAR(n) and you enter a string with size 
> < n, McKoi seems to pad your string with whitespace.
> 

Is this sort of behaviour vendor-specific or does the Ansi standard 
specify the expected behaviour?

What do Sybase, Microsoft and Oracle do in the same situation?

Regards,
Mamading Ceesay

"Don't worry about what anybody else is going to do. 
The best way to predict the future is to invent it."

-- Alan Kay