Erin

I am trying to pull a field where if the data value has 8 characters, strip off the first and last character. If data value has 6 characters, leave...

Perry.Pierce for a fuller explanation of the LIKE comparison read

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/581fb289-29f9-412b-869c-18d33a9e93d5.htm

It shows in detail other possible matching patterns that make LIKE a potent search tool in a SELECT statement.

Now a question...

I would like to thank all who have commented. I have learned a little more to apply to any additional QOD that I may submit. Please note that...

Have you examined the @@IDENTITY function check BOL for a complete description.

insert into PERSON (PARTYID, NAME, DOB, DATE_TIME_CREATED, DATE_TIME_MOD)

values(@PARTYID, @NAME, @DOB, GETDATE(), GETDATE())

SET @Key = @@Identity

Got carried away here and...

You might want to read the description for SYS.SYSTEM_COLUMNS catalog view in Books On Line. It contains the max_length for columns expressed in bytes. It does not have...

This returns a single recordset ... and might be what you are looking for

took this example from BOL

USE AdventureWorks;

GO

SELECT

RANK() OVER(ORDER BY SalesYTD DESC) AS...

Great question ..Now for a trival comment the link shown for the correct answer

Displays a MSDN page titled Using SQL Server Profiler:

However this link http://msdn.microsoft.com/en-us/library/ms188786.aspx yields sys.server_prinicipals(Transact-SQL) produces from BOL...

In my install I found it at:

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SQLwb.exe

must say that it did display when I clicked "Start", then "Programs" expanded programs, as one normally would, and SQL...

The only help I can provide and it is not much, have you reviewed the Codeplex project on msspatial extensions, which apparently exists because of 2005's ability to support Common...

A ha so you did post some more...

To help those who can help you.... please follow the posting protocol as covered by the article in my signature block.. Thanks

Although not a direct answer to your question you might want to visit Books On Line for SQL Server 2008 in which Microsoft introduced the Hierarchical data type. This...

Tongue in cheek when I say this:

Luke L .. for shame, for shame. Just

imagine what would happen to the Forums if they

followed your recommendation. If memory servers

me correctly...

Your posted reference refers to SQL 2000 and you have posted your question to a SQL 2005 forum. There are many debugging tools available for specific functions in SQL...

Bpowers:

Identity values are normally automatically incremented when a row is added to a table. Why...