It's standard practice in many programming languages that if you need to include the string delimiter inside a string to use a double delimiter.  So, you just need to double...

I think that you are looking to CREATE SYNONYM.

Drew

It's not just a language barrier.  The expected results are logically inconsistent.

For example, this combination produces three results:

INSERT INTO #StateDistrict
VALUES
  (1,40,50)

You're getting an error, because both sys.master_files and sys.databases have a column "name".  Just specify which one you want in your select statement.

J. Drew Allen

Business Intelligence Analyst

Philadelphia, PA