basic question on MID function 1

[psimon1]

Hello

I'm more of an Access guy and I know that there are differences between Jet SQL and TSQL. We're running SQL server 2005 and I can't seem to find an equivalent to Access' mid function. In other words, I really liked how I could pull part of a record as follows:

MID(NAME, 3,2) AS NAME PART

***

Johnson becomes "ns"

How would I do this in a TSQL command?

Thanks, all.

 

[fuzzyocelot]

Try the SUBSTRING function. Here's the syntax:

SUBSTRING ( expression ,start , length )

 

[ESquared]

and keep your colum name without spaces or surround it with square brackets NAMEPART, [NAME PART]
And Johnson becomes "hn" I think.

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]