thanks,

could u tell me what is the function of AS in sql?

Thanks again...

>You should be able to do it exactly as in your example. You can use AS to give the result of the function a field name, like this:
>
>SELECT *, MyFunction() AS mycolumn ...
>
>VFP will probably choose the size and type of the field based on the result of myfunction() in the first row returned, so you may want to make sure the string it returns is always the same size.
>
>>Hi to all.
>>
>> Can i insert a function in SQL or select statement?
>>
>>e.g. select [field1], field[2], myfunction() from mydatabase ....
>>
>>Thanks,