>Hi all
>How to write an SQL function syntax something like command "Gather Memver" in VFP
>example I got some memory variables m.id, m.name, m.address,........
>so I defined a function call GatherMemvSQL
>Once I call this function all the memory variables can insert into or update into SQL table
>instate of writing a long sql command for insert or update.....

If we are talking about SQL Server, then there is no other way except constructing the long SQL Insert or update command.