Hi,

> I have other problem.
>
> In a table I have a column named status type char(1).
>
> I need a statement to show the records based on this table:

Create for example a table StatusTypes with Primary Key StatusType Char(1)
and a field Description varchar(35).

Fill this table with :

> 0 - No Checked
> 1 - Checked
> 3 - Returned
> 4 - Cancelled
> ....9

JOIN this table in your SQL statement like :

SELECT
o.OrderNumber,
st.Description
FROM
Orders o
JOIN StatusTypes st ON (st.StatusType = o.Status)

Regards,
Arno