Helen,

> >If I have strings like that and i want to insert it into the
> >databsae how do i solve this problem.
>
> Well, define the fields as char to *store* the trailing white space
> characters (making 'abc', 'abc ' and 'abc ' three distinct values)
> but nothing is going to help you to get past the equivalence test
> rules. It is just not at all a bright idea to allow trailing white
> space to be meaningful.

Is it me, or this this wrong?

Won't a CHAR -always- return the value with padded spaces?
That is, 'abc' will be returned as 'abc___' (where "_" means a
padded space) if the column is defined as CHAR(6) and 'abc '
will be returned as 'abc __'?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com