[Tutor] formatting sql Was: Some help Please

[Alan Gauld]

On 15/02/12 18:03, James Reynolds wrote:

> >    In you table the acc_id is 'mn0001'
> >    In your sql Acc_ID = 'MN0001'
> >    Why the difference in case?
>
> Normally, sql doesn't care about case with respect to table names. I
> believe in certain implementations they are always lower case, even if
> you pass an upper.

The issue is not the table (or even column name) its the value within 
it. Comparing 'mn0001' to 'MN0001' will fail.

-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/