Thanks all for the answers I'm getting from you guys. You guys are great. Here is another one ........ Can you use a SELECT statement with [INTO] for a view like they are used for in a table?
Something like

SELECT view1

INTO view2

OR

SELECT table1

INTO view1.

I'll appreciate very much.

Thanks in advance.
Richard.