>Thanks for reply
>
>No friend
>i have tried
>but error occured
>incorrect syntax near 'c'
Don't use square brackets. They are used for different things in SQL Server. If you need to have a quotation mark in some text just double it.
As I said look at Cetin's answer, he provided code that must create a View for you. Did you see how Cetin finished view definition?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.