Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Left, Right, Mid Functions in Transact-SQL

Author  Topic  SQLouie Starting Member 2 Posts Posted - 2001-02-16 : 15:11:50 Hello, I'm fairly new to SQL Server and Transact-SQL development. I have a Microsoft Access SQL Statment that I'm attempting to convert to Transact-SQL but it does not work due to the Mid Function I've included. Does Transact-SQL support Left/Mid/Right functions? Thank you, Luis. SELECT Count(dbo_IH_Events.strIncident) AS CountOfstrIncident FROM (dbo_IH_Events INNER JOIN dbo_IH_InvolvedPeople ON dbo_IH_Events.intEventCode = dbo_IH_InvolvedPeople.intEventCode) LEFT JOIN dbo_IH_People ON dbo_IH_InvolvedPeople.strID = dbo_IH_People.strID WHERE (((Left([strRoomNumber],1) & Mid([strRoomNumber],4,1))="1N") AND ((dbo_IH_Events.strIncident)="Falls")); Luis - Programmer/Analyst - INGLIS House - A facility dedicated to meeting the needs of people with disabilities. http://www.inglis.org