Substring

• rbarnes 77603

  Grasshopper

  Points: 15

  More actions

  December 17, 2009 at 11:22 pm

  #228621

  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.