Query a string of text?

• Ron-279530

  Ten Centuries

  Points: 1381

  More actions

  August 3, 2006 at 7:55 am

  #115008

  Can someone help me with how to query a string of text? Below is a string of data from a column in my database called 'calldata'

  1 1724 ^E16107/30/2006SUSAN07/30/200616

  What I'm trying to do is see what different values show up between the tags for order version.

  Thanks

  Ron

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  August 3, 2006 at 8:28 am

  #653122

  Use CHARINDEX function.

   

  SELECT Calldata, CHARINDEX('/', Calldata) FROM [Ron's Table]

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• Ron-279530

  Ten Centuries

  Points: 1381

  More actions

  August 3, 2006 at 2:05 pm

  #653206

  Thanks! Once again you've been a great help Peter!