Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-26 : 14:33:44
|
John H. writes "Is it possible to extend the SQL functions available in a SELECT statement and create your own via stored procedures or COM methods?
As an example, say you wanted to create your own HASH or SOUNDEX function that computes an identifier/number based on string content such as:
SELECT name FROM info WHERE SOUNDSLIKE(name) = SOUNDSLIKE('sqlteam')
or,
SELECT name FROM info ORDER BY MyPriority( info.hits, info.lag )
We would like to avoid having to invert this logic by creating a row-by-row FETCH loop with an algorithm inside of it, or saving stuff in work tables, etc...
This functionality was available back in Clipper/XBase UDF (user-defined function) days .. has it gotten lost along the way?" |
|
|
|
|
|
Custom Functions?