Say I have an SQL like

SELECT Field1, Field2, Field3 FROM MyTable

Now I want to put the word January as the first column.
Note January is not a field name

In other DB Engines I have done

SELECT 'January', Field1, Field2, Field3 FROM MyTable

This works ok with other DB Engines but not with DBISAM
I am assuming it can be done but the syntax is wrong?

Any help would be great. Thanks

Dont worry it does work exactly the same.

Tell a lie. That only completes the Column Label.
How can I make all this columns values 'January' ?

Dave


I just tried it here and it works fine.

Roy Lambert

Hi,

You could try

SELECT CAST('January' AS VARCHAR(10)), Field1, Field2, Field3 FROM MyTable

Regards.

Julio.


> Tell a lie. That only completes the Column Label.
> How can I make all this columns values 'January' ?
>