General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only