Or this

SELECT LEFT(@Input,PATINDEX('%[^0-9]%',@Input+'Z')-1)

Not aware of a function, per se but you could try this

SELECT CASE WHEN PATINDEX('%[^0-9]%',[Input])>0

THEN LEFT([Input],PATINDEX('%[^0-9]%',[Input])-1)

ELSE [Input]

END

Always best done in presentation (app) but if you truly want to do it in sql then

DECLARE @maxemp int, @maxman int, @count int,@managerid int, @sql varchar(1000)

SELECT @maxemp = COUNT(DISTINCT...

SELECT t1.EmpID, t1.PayCode, t1.PayAmt, t2.PayCode, t2.PayAmt

FROM #table t1

INNER JOIN #table t2

ON t2.EmpID = t1.EmpID

AND t2.PayCode = 2

AND t2.PayAmt <> (t1.PayAmt * 1.5)

WHERE t1.PayCode =...

It does not matter if OpeningDate is NULL or '', CONVERT will not produce the error (you will get NULL for NULL date and '1900-01-01' for '')

The error is due...

Search the Internet there is a lot about this.

This may help

http://www.dbazine.com/celko1.html

This is lifted from a page on the Internet

DivideBy:

You may also perform a set division operation on two tables....

mmmm different

Nice deviation from the norm

DIVIDEBY is not a SQL operator or command, it is algebra

I...

Duplicate post.

See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=166820

Not sure if this is what you want. It all depends on what you want to do with the data from the additonal tables.

LEFT OUTER JOIN E__EMPLOYEE e

ON [result].EMPLOYEEID...

Yes, if there is no space then it makes it difficult to split. There is another thread on this forum that discusses this topic and I think it assumes that the...

SELECT LEFT(@postcode,CHARINDEX(' ',@postcode)-1)

Phill is right you will have to use either a string or a variable you cannot use another column in CONTAINS.

The error is in the first line as not tablename...

The use of float aside, I think there is a problem with your statement.

If you are converting numeric(5,1) to float then you will get either an exact value or an...

A bit late, but....

SELECT LEFT(@inputstring,PATINDEX('%[0-9]%',@inputstring)-1)

I can't get it to work at all