UPPERCASE words only

[trenttc]

I want only uppercase words from a descripton field that starts with all upppercase words followed by: mixed case or numbers or hyphens or quotes, etc.
SET Desc = SUBSTRING(Desc,1,PATINDEX(only uppercase words);

 

[gmmastros]

Just to clarify...

If the DESC column looks like this...

[tt][blue]HELLO WORLD - this is just a test[/blue][/tt]

You want it to end up being...

[tt][blue]HELLO WORLD[/blue][/tt]

Is this correct?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

Take a look at this...

Declare @Temp VarChar(100)

Set @Temp = 'UPPER CASE words only'

Select SubString(@Temp, 1, PatIndex('%[^A-Z ]%', @Temp collate SQL_Latin1_General_CP850_BIN)-1)

Normally, SQL Server is not case sensitive (depending on your collation). By using a binary collation SQL_Latin1_General_CP850_BIN (or any other case sensitive collation), you can achieve your goals.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[trenttc]

Select SubString(@Temp, 1, PatIndex('%[^A-Z ]%', @Temp collate SQL_Latin1_General_CP850_BIN)-1) gives me "syntax error near collate".
I tried it without the collate clause:
Select SubString(@Temp, 1, PatIndex('%[^A-Z ]%', @Temp)-1) and the result is just 'U'.
When I try it on live data, I get "cannot convert to a numeric".

 

[gmmastros]

I tested that block of code before posting. Are you using Microsoft SQL Server?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[trenttc]

Sorry. Server is Microsoft SQL Server but this app uses Sybase. Is there a thread for Sybase?

 

[gmmastros]

forum187

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom