CREATE TABLE #Yaks (

YakID int,

YakName char(30) )

select name

from tempdb..sysobjects

where name like '#yak%'

Read this:

http://www.sqlteam.com/article/temporary-tables

Now I ran the code from the above, using two separate connections and this was my results:

#Yaks___________________________________________000000000035

#Yaks___________________________________________000000000033

So...

Here this works for me.

SELECT Name,REVERSE(right(REVERSE(Name),12)) from sys.databases

model model

msdb ...

It depends

I used a table to illustrate what could/would happen when using just the LEN function. Please review what I...

For triggers read this.

http://msdn.microsoft.com/en-us/library/ms189799.aspx

Suggest you use google to search for "Cascade delete"

Phil Parkin (4/29/2012)

---

Indeed & a fair guess. But her post immediately after your suggestion seemed to indicate that things...

Here is a sample: I guessed what Tara-1044200 was attempting to...

This may be your problem

CREATE TABLE #T (Name1 VARCHAR(20))

INSERT INTO #T

SELECT 'ABCDEFGHIJKLMNOP' UNION ALL

SELECT 'ABCDEFGHIJKL' UNION ALL --12 characters

SELECT 'XYZ'

SELECT DATALENGTH(Name1) AS 'Datalenth' FROM #T

Returned:

Datalength

16

12

3

For the two shorter entries...

Jeff Moden (4/26/2012)

---

If I...

Nice simple/easy question to start the week ...........THANKS

Microsoft has available (for free) Upgrade Advisor software which you can run before attempting the upgrade... it will advise you of most problems which you might encounter.

http://www.microsoft.com/en-us/download/details.aspx?id=11455

WayneS (4/27/2012)

---

Well, I see that Steve is catching up from being in England... I have an article and a QotD being published on 5/10. ...

For those that would like a...

Steve Jones - SSC Editor (4/26/2012)

---

Current QOD status. I have them scheduled through May 9, plus a few random days out past that, but I also have 16 submitted right...

Alas and alack, a day late and a dollar short, but I ran across this article today, and it might be what is needed.

http://www.mssqltips.com/sqlservertip/2676/export-data-to-an-earlier-sql-server-version/?utm_source=dailynewsletter&utm_medium=email&utm_content=text&utm_campaign=2012424

The author is: By: K. Brian...

SceloM (4/25/2012)

---

Thanks,

So having a check for char(9), char(10) and char(13) should cover me for the spaces?

I have implemented the function on my full query and seems to be working...

Here is a general method to determine what that last character is.

[DECLARE @A2 VARCHAR(50)

SET @A2 = 'GAUTENG EAST 1'

--The @A2 has a horizontal tab as the last...