Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Substring Expand / Collapse
Author
Message
Posted Thursday, December 17, 2009 11:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 18, 2009 7:59 AM
Points: 1, Visits: 1
I am trying to determine the value in a field in one of our tables that exists between 2 different delimiters. Any ideas?

Example:

Field name is : RAD
Field contents is: 351 S. Hudson Ave. # 105

I need to determine the value between the space following the 351 and the # before the 105. The field is variable lengths and may or may not contain the #.

Thank you.
Post #836142
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse