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

Jeff,

Nice solution if it was possible. As stated in BOL (SQL2K SP3) and in practice escaping double quotes (\") is not allowed with BCP.