i checked few of the string functions which can be used with unicode dataypes on Latin1_General_CI_AS collation
list of functions that can be used with unicode datatypes
len
substring
charindex
patindex
cast and convert
ltrim and rtrim
stuff
left and right
upper and lower
space
if you know any function that i missed and can be or cant be used with unicode dataypes, please let me know