Storing a Function (Getting Syntax Error)

[kenny.fsw]

Good morning all,

I have never stored a function before, so I am not sure if I am doing something wrong or not.

I want a function to be able to extract the numerical values from a string. The string is usually "1111 aaaaaaaa" The numerical length can be 1-6 chars and the text is any length (it is a site code and then site name). The total field is Char(30).

I found a function Here
When I try to create this function using MySQL workbench it gives me the following error:

ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@strAlphaNumeric VARCHAR(256))

Could someone please tell me what I'm doing wrong?

Below is the Function taken from the link above.

Please Login or Register  to view this content.

[natefarm]

You sure you're on the right forum? We can create functions in VBA, but I'm not sure if that's what you're trying to do.