>ok thanks again, but another question as I add a char expression in dynamic SQL, for example, @ x = 'gdfgfd ggd'
I am not sure I understand. If you need to add a character constant, double the single quote, e.g. instead of
'Test'
use
''Test''
If it's not broken, fix it until it is.
My Blog