The table is big as it contains all airports in the world. I am a beginner, so can you tell me how to that (create an array). I am using...

Thank you all for the help

thank you

Yes I have been using it for more than a year now

Where to put all that code?

The data type for that field is smalldatetime but it even would be better to keep it as month year only, however this data type format is not available

When the user enters the expiry date as e.g 05/06 in the form, this is converted into 05/06/2005?

Can you tell me how as I can use this at a lot of situations in my program

This worked great, thank you very much

Thanks but when I try to run it I get the following error message:

Server: Msg 141, Level 15, State 1, Line 9

A SELECT statement that assigns a value to a...

       Here is an example of what I get when I run a report to create invoice based on the above view. As you see it is not properly formatted?

Can you post a sample of the data?