This disclaimer is intended to cover all software/freeware, and other various files which are downloadable through or from this site. |
Joe Garrepy, isp, and web host can not be held responsible for any software downloaded from this site. All freeware is downloaded at your own risk. Software which is listed on this site is assumed to work properly, but may or may not have different effects on different computer systems. The same rules apply to these programs.
Joe Garrepy assumes no responsibility for those unusual occurrences where software has adverse effects on users computer. Joe Garrepy does not warrant these programs/files, and as such, can offer no guidelines in which to use them.
All freeware/software/files, trademarks, service marks, and copyrights are acknowledged as belonging to their owners. Any of these which the owner wishes to be removed will be done so immediately.
By downloading any software or viewing pages in which software can be downloaded, you agree to be bound to this agreement.
JoeGarrepy.com SQL Server T-SQL String Functions
Since I've started working more heavily with SQL Server I decided the best way for me to learn
T-SQL was to convert some code written in Oracle's PL/SQL to T-SQL. My first thought was to convert
the Oracle String Package since I use it so heavily in
code that I write. Since SQL Server doesn't have PACKAGES I've been working to move each function in
the STR package in to a User Defined SQL Server Function. I've also decided to JavaDoc/PLDoc the
Function in the hopes I can get WinDDL to work on SQL Server the same way it works on Oracle. I guess
that would be a TSqlDoc?
So far I've converted the following:
|Function Name||Returns?||Conversion Date||Converted?
|SPLIT_ARRAY|| ||No Equivalent
|SPLIT_PIPE||Result Set of VARCHAR||1/13/2006||COMPLETE
|IS_NUMBER|| ||ISNUMERIC built-in
|IS_DATE|| ||ISDATE built-in