your query will be like that....
select ClientCode from TableName where Address like 'here your search parameter'
e.g
select ClientCode from TableName where Address like 'Mumbai'
OR
select ClientCode from TableName where Address like '%here your search parameter'
OR
select ClientCode from TableName where Address like '%here your search parameter%'