I have a column in table which stores the actual signature from the singature pad. In the table it is stored as varchar(max) datatype and sample data looks like below. Below data is the actual signature of the person.
CREATE TABLE #test
([Signature] VARCHAR(MAX))
INSERT INTO #test
SELECT '/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/wAARCAA8AKIDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9U6KKKACiiigAooooAKKKKACiiigAooooAKKK+dvix+2x4U8GeJ5PBPgfS9Q+LXxJ5A8NeFQJRbMDgm6uOY7dQfvE5K91A5oA+iGYIpZiFUDJJ6AV8z/EP9ubw7beJZ/Bfwm0K/8AjT8QI/lfTfDbD7DZHON11ekGKJQeDgtg8HbXNL+zV8Wv2lmF58fvGP8Awj3hOXDD4aeCJ2ht2X+5e3gO+bj7yIduRlWHSvpj4efDPwp8JvDUHh/wd4fsPDmjwfdtdPhEascY3MRy7HuzEk9yaAPmiD9k/wCIv7Q88epftG+NzNojMJY/ht4NlktNKj5yFupwRLckdxkAEfK2DivqHwX4G8PfDnw7a6D4X0Wx8P6NajEVjp0CwxL6nCgZJ7k8k8kmtyigAooooAKKKKACiiigAooooAKKKKACisLQ/HnhrxNrmr6NpHiDS9V1fR2RdSsbK8jmmsmfdsEyKSYydrYDAZ2n0rdoAKKKQkKCScAdzQAtFfLXxE/botE8VXvhT4N+CNT+OHiLSwZdX/sCZYrDT41yWVroqyPMQCFjTO45XO4ba9Z+A/7Q/gz9onws+seFL5/tFq/kalo18nk3+mTjIaG4hPKMCCM8qcHBOKAPFP24vhF8f/is+m2vw18RWcfgRIV/tjw1aag2lanqbb23ot5scLGybV25QctkNxjkfhD+0f8AD39k/wAOReGPF3wJ8T/AKyQqLjUhpx1TTZnHG6TUIAzzN/tMCcEc4r7lpskayxsjqHRgQysMgj0NAHE/Db44fD/4w2guPBXjLRfEy7dzR6depJLGP9uPO9PowFdxXgvxJ/YY+CPxPvP7Qv8AwLY6PrSt5keseHS2mXaSf398BUM3u4auHP7M3x1+FPz/AAr+Pl7rmnx/6vw/8TrQanGwHRTeoBMijphV6fSgD6yor5NP7Uvxp+FXyfFj4Aarf2Mf+s8Q/Da5XVoGHd/srETRqOpLHp24r2v4JftCeBP2hvD1xq3gjW01FbSTyL2ymjaC7speRsmhcBkPBwSMHBwTigD0eiqWs63p/hzSrrU9Wv7bTNNtYzLcXl5MsUMKDqzuxAUD1Jri/g/8fPAfx8sNZvvAXiCLxFZaRenT7q5gikSMTBQ2FLqA64YYZcqexNAHoNFFFAHn3xqs/iffeGLaP4U6j4Z0zXvtSm4m8UW880H2fa2QgiIIfds65GN3fFeKj4Z/tdal/wAfPxn8DaPn/oHeFjPj6ea3+cmvquigD5U/4Z3/AGmL75r39q42/pFY/D/T1AP+8XyfpSj4E/tSaWP9E/ae0/V1H3Y9T8A2UXHYFo3yeg568n2r6qooA+IfjNr37XHwB+F/iLxzc+NPAPjHT9Ctvtc9onh64juJIwwDMAjgYUHcxyMKGPYV81/tI/FD9rjx/wDCr4fX2s694X8OWPjuSC10nwl4Fu5Y9U1nzlDKzODJ+72MpbbMqAOAwyQK/Ub4s+L/AAv4D+GviTXfGs8EHhSzsZW1E3K7kkhK7THt/iL7tgXqxYAcmvzG/Yc8a+APgv4/1bXvjbqt/wCD7/RtJhb4e2Pi+Xf9j0G7kmlU24UEtKc7WOMhSVHGQADo/hLa/F//AIJmfA/XNT1f4S+E9U0oXK3Ws+IE8UrFd3bM4SKMKYyTt3bVRQeWY4yWr6R/Zd/bJ1zx9rGk+D/i/wCHLbwH428QWMet+HHtnJsNbsJUEiCByzfv41YB4y2TjIA5A8015bP/AIKa/FC9s9KuZ5vgL4KtZRFetFLBHruuTQsqMFcK3l26vnkA7vVZBjpv2c/hdoH7W37A3w90DxYk9lrOgwvp1pqlo3l32jXtlM8EUsLjlXVYozjoQcH2APoj46ftH+A/2dtCi1Dxhq4huro7LDR7NPP1DUJM4CQQD5nJJAzwoJGSM14GPhz8Zf2zj9o+JE178G/hHNzH4I0ufbrWrxdvt84/1KMOsK84JDAEBq9P+Bn7HnhX4Ra9L4w1rUL/AOI3xMuh/pPjLxK3nXQ4xst1JKwIBwAvODjcRgD3ugDmfh18NPC3wk8KWnhvwdoVl4e0S1H7uzso9qk92Y9Xc45ZiWPcmvHPjz+yYvjPxTH8SfhnrZ+HPxgs0xFrlqn+i6ogx/o9/CBiWM4A3EFhhfvBQtfRNFAHyDoH/BQCHwTHN4Z+MvgPxL4U+JOnkR3GnaJpM2o2moL2ubSWMEGNsdGOQeMtgmtQ/t5T6xx4Y/Z/+Mmu5+7cS+GRaWzfSSST+lfVVFAHyof2k/2iNe48P/ssX0ETdLnX/GFlZ7frFtLfkaa3iP8AbO8QZ+w+EPhH4TRv+gzqd9eOo/7YAAn9K+raKAPBf2Y/2lp/i82teDvGulR+EPi94Xbyde8OZIRl423dqSSXt3BUg5O3cASQVZvjz/go18WfBfwL+M+n+IPhtFrnh34924hmvdS0i02abeWj4Jjv1YbbglQMFVJ4AZsqoH17+1D+zbefFCTSPHngHUE8L/GPwrmXQ9bHEdynJayuh/HBICw5ztLHsWDa/wCzH+0lZ/H7w3f22oadJ4X+IPh6UWPibwtdcTafcjI3KDy0T4JR+QRxnINAH5t/Dn9qP4WfHvUj4i/ar8aeJNV1K2vC2m+AbTS54fD8KD7kojg3NOfeUg9QQ45r1D9jr9uH4H/BofGBdQvbrRrPXPHuo6lo9pp2hXBiTTSsSW2Fjj2x8Kw8vAK4HFfdX7QH7N3g39o3wzDpviW2lttTsX8/Sdf05/J1DS5wQRLBKORyASpypwMjIBHwz+wV+06n7P3hG70T4oWV5ZeDvEnijUptM+Jc/wA1ndXvm+XLHeEE+Q7NEWDE4IJzgKWoA99b/gqx+zkjFW8V6mrA4IOhXmQf+/dFfit8RtX8T/Ej4heJ/FqWmpFNe1S61UFVfGJ5Wl4xx/HRQB/TLRRRQAVn+IbK+1LQNTtNL1E6PqdxayxWuoiBZ/ssrIQkvlt8r7WIbaeDjB61oUUAfAfjb9hP9oP446pFo/xT/aGtta8E2U6ahapYaBBDNLdIfk823VEj2gFjhnkGf4e9djr3/BPXXfG2p2mpeK/j14t1zUbRDHBdtpliksKE5KxuY2KA+gPXmvsuigD5Nf8AYQ123ss2P7SnxjtdRhANo511GtI3H3d9uI1EieqbgD612H7F/wAAvGP7O3gXxXoHjLxFp3ie61LxLd61bX2nQtCDHOsZbfGVCxsZFdtiZUbuCeg+gqKACiiigAooooAKKKKACiiigAr5s/ab/Z517VPEdh8YvhHNDpHxh8Pw7PKkO228RWQwXsLoZAOQPkc4wcDIwrJ9J0UAeTfs+/tHeHv2gPh5P4hsYptI1XS3e017w/fDbd6Rdx58yGVTg8EHa2BkDsQwHjP/AAT08C6N49/YD8I6T4q0m11rTNeOpzX1jexCSKUPqFwRkHvgKQeoIBByAa8z/wCCily/7NPxC8GfFrwCf7H8T+LbmTw34hhUn7HqtqYvlaeIYzKnG2QEEYGc4r6E/wCCe1slr+xh8KUjGFOlFyPdppGP6k0Adxo/7Mfws0HSLLTLHwTpkVlZQJbQRsrOVjRQqgsxLNgAckknuTRXp9FAH//Z'
SELECT * FROM #test
How do i decrypt this data so i can print actual signature on my report.
any help much appreciated
- Edited by SQL Insane 7 hours 49 minutes ago
- Changed type Eric__ZhangMicrosoft contingent staff, Moderator 1 hour 18 minutes ago