Condition                        Columnname
akraft,crunckel	                   TN
AL,AZ	                          State
Atlanta,Austin-San Marcos	   MAC
aney,aventura	                  Area 
Alexandria, VA,Arlington, TX	   Market
Alpharetta,Alexandria	         City
001,002	                          StoreS
SameStore,HeitmanI	            Store Type
InLast6Months,CS-CC	            Space Types

Condition                        Columnname
'akraft','crunckel'	                   TN
'AL','AZ'	                          State
'Atlanta','Austin-San Marcos'	        MAC
'aney','aventura'	                   Area 
'Alexandria', 'VA','Arlington', 'TX'   Market
'Alpharetta','Alexandria'	           City
'001','002'	                           Stores
'SameStore','HeitmanI'	            StoreType
'InLast6Months','CS-CC'	            SpaceTypes 

declare @a varchar(100) = 'akraft,crunckel';
set @a = ''''+replace(@a,',',''',''')+''''
select @a

declare @a varchar(100) = 'akraft,crunckel';
set @a = ''''+replace(@a,',',''',''')+''''
select @a

Alexandria, VA,Arlington, TX

'Alexandria',' VA','Arlington',' TX'

declare @a varchar(500)
set @a = 'Alexandria, VA,Arlington, TX'
set @a = replace(''''+replace(@a,',',''',''')+'''',''','' ',''',''')

select @a

declare @a varchar(500)
set @a = ' Alexandria , VA , Arlington , TX '
set @a = replace(''''+replace(@a,',',''',''')+'''',''','' ',''',''')
select @a

declare @a varchar(500)
set @a = '  Alexandria  ,        VA     ,     Arlington   ,  TX '
set @a = REPLACE(''''+REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(@a)),'  ',' '+CHAR(7)),CHAR(7)+' ',''),CHAR(7),''),' , ', ','),',',''',''')+'''',''','' ',''',''')
select @a