Thanks that will work for the inline

I have this idea which works row by row, but I need it to be inline sql

DECLARE @drugName VARCHAR(20), @amp_position INT

SELECT @drugName = '100MGWaldorf'

SET @amp_position = CHARINDEX( 'MG', @drugName)

SELECT...

Found an interesting issue, if you only have 2 values like

ased-werd

it fails with

Msg 536, Level 16, State 5, Line 1

Invalid length parameter passed to the SUBSTRING function.

Duh sorry forgot to create the function

What is the dbo.charindex2?

Now that I am turning 50 it seems more frequent

Duh, thanks for pointing out the obvious, can't see the trees through the forest

Sorry, what I am looking for is that if I have 2 instances of SQl Server on a Standard edition SQL 2005 Active/Passive Cluster, that I expect both instances to...

thanks

No, two times when this happened this process got stuck and I could not kill it, had to reboot

Never paid much attention to it, but the log shows is shutting down and starting up several times a day, is that related to when it sends out messages?

5 records with these names

InternalMailQueue

ExternalMailQueue

QueryNotificationErrorsQueue

EventNotificationErrorsQueue

ServiceBrokerQueue

We have nothing running, but it seems there are related messages to dbmail in this, it seems all internal to sql server

OK I give up, removing indents worked

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near...