@awood02:

That works perfectly thanks - I knew it had to be something simple like that case statement - ?I think I had just been staring at it for too long.

Jeff...

steveb (8/12/2008)

---

I have done something similar using PATINDEX and a while loop, try this code.

DECLARE @i int

DECLARE @String varchar(100)

SET @string ='Starsky & Hutch Ltd.'

SET @i = (SELECT PATINDEX('%[^a-z^0-9 ]%',...

Hi,

I have done this - the issue is...

View definition as requested:

SELECT RTRIM(ISNULL(Pers_FirstName, '')) + ' ' + RTRIM(ISNULL(Pers_LastName, '')) AS Pers_FullName

, Capt_Order AS Comm_PrioritySorted

, RTRIM(ISNULL(Pers_PhoneCountryCode, '')) + ' ' + RTRIM(ISNULL(Pers_PhoneAreaCode, '')) +...

I didnt mention is specifically in my first post, but all 150+ other users are working fine - it is only this one user being affected. Dont know if that...

noeld (6/27/2008)

---

Probably on the definition of either one of the tables in the view or the view itself you have exceeded the maximum row-length. The Addiditon of "order by" is...

Not as far as I know - any way I can be certain? (Sorry, amateur here)

Wow guys thanks so much for everyones help.

In regards to the questions around get_next_CRM_ID, I dont really have a level of skills that would make me feel comfortable bypassing and/or...

Basically it gets the current valid ID from a tracking table, then updates the table with the current value +1 ready for...

Basically it is a proprietary SP provided by a SQL based web application for the purpose of generating...