• i have a big proof of concept CLR project that is filled with items i either create myself, or find here on SSC.

    I just keep adding to it as I encounter ideas.

    some of the things I've done in it:

    Regular Expressions.

    Read Write Files and Folders, including binary/blobs.

    Send Email.

    Read Email via POP3.

    Read Email via IMAP.

    PGP Encryption/Decryption.

    AES Encryption/Decryption

    Zip/Unzip Files.

    Send/Get files via FTP and SFTP.

    Convert RTF to text/text to RTF/HTML to RTF.

    Export a table or query to multiple formats via a web service.(excel/word/pdf/mht/html/more)

    A different write to PDF function.

    Read Excel without Office DLL's.

    HTML Encode/Decode functions, UrlEncode/Decode Functions.

    The usual caveat here applies, just because it can be done in TSQL, or CLR, does not mean it's the right thing to do the right place to do it.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!