Hi I am trying to convert or decode a column that is in base64. I have query that can convert one name at a time but what i want is the query to do is convert all the names into a new column. Sorry for being so green at this.
here is the query that dispalys the names
,[User] (this is the one that is in base64!!!)
I did find this fromt the web that can convert a single name when put in the variable of @data
-- set the base64 encoded varchar.
@data ='TDk5OTM0==' (here is where i want to put in more than just one value)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.