Very Computer

thanks

Daniel Bogesdorfer
Senior Programmer / Analyst
University Of Pittsburgh

If [Journal Name] is, say, varchar(80),

REVERSE(
  SUBSTRING(
    REVERSE([Journal Name]),
    1+CHARINDEX(':', REVERSE([Journal Name])),
    80)
)

is [Journal Name] with everything after the last colon deleted.

Steve

SELECT LEFT([Journal Name],LEN([Journal
Name])-CHARINDEX(':',REVERSE([Journal Name])))

SELECT SUBSTRING([Journal Name],1,LEN([Journal
Name])-CHARINDEX(':',REVERSE([Journal Name])))

--
Darren Brinksneader MCDBA, MCSE+I, CNE, CCA, MCT, CTT

To find the last position of the colon in each string:

To get the new string:

                                   from rac order by rd'

stevie
www.angelfire.com/ny4/rac/
Rac (relational application companion)
for s2k available soon).

select Journalname,
reverse(Journalname),reverse(Substring(reverse(JournalName),charindex(':',re
verse(JournalName))+1,200)) from Journals

Here is the string I tested:
Start String
----------------------
Abdominal imaging. (Abdom Imaging): 1996 1997 1998 1999 2000

String Reversed
----------------------
0002 9991 8991 7991 6991 :)gnigamI modbA( .gnigami lanimodbA

String I needed
-----------------------
Abdominal imaging. (Abdom Imaging)

--
Daniel Bogesdorfer
Senior Programmer / Analyst
University Of Pittsburgh

Quote:> I told myself "quit relying on others to give you the ansswer" and came up
> with the code below.  Below is the select statement to get my substring by
> finding the last position of a character in a string.

stevie