question

attca2k avatar image
attca2k asked

How to write a function that uses dynamic EXEC to return results

Attached is a table of email address formats. The question is how to write a function that inputs an email address, first name and last name, and outputs the index of the table to which email format is being used. The table's field formula has the sql statement within, so using a cursor to that table and using EXEC (formula) does not work.

The idea is to have the formula's in a table, just like how our brains work, and using A.I. to determine whether email address is <first initial>+<last name>@domain or some other formula.

tablesfunctionscursordynamic-sql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.