Programming/
 Tools

      Oracle
      JavaScript
      C#
      SQL Server

 Fun Stuff
      Music
      Martial Arts

 Other
      Main


DISCLAIMER
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 NameReturns?Conversion DateConverted?
SPLITVARCHAR1/13/2006COMPLETE
SPLIT_ARRAY No Equivalent
SPLIT_PIPEResult Set of VARCHAR1/13/2006COMPLETE
IS_UPPER_CASEINT1/17/2006COMPLETE
IS_LOWER_CASEINT1/17/2006COMPLETE
IS_MIXED_CASEINT1/17/2006COMPLETE
IS_NUMBER ISNUMERIC built-in
IS_DATE ISDATE built-in


SPLIT T-SQL User Defined Function

SPLIT_PIPE T-SQL User Defined Function

IS_UPPER_CASE T-SQL User Defined Function

IS_LOWER_CASE T-SQL User Defined Function

IS_MIXED_CASE T-SQL User Defined Function


If you find any bugs or want to contact me I can be reached @ doughjoe77@hotmail.com.