how to create a function in mysql and code it to vb6??

You need to code the function in database and call the same from vb 6.0 as part of your sql code, but if it is a procedure you need to create command object (adodb) in vb .

thankz what is the syntax in mysql server because its diffrent syntax in sql server.. can you please site me an example??

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.