display specific string and display that position in sql server

• asranantha

  SSCarpal Tunnel

  Points: 4246

  More actions

  April 30, 2013 at 8:47 am

  #292769

  hi firends i have small doubt in sql server plz tell me how to solve

  to find the specific charter and that posittion. here i want find sas string .which position its there and diplay with sas and position in below table

  table data contains like

  name

  sas programer

  sas programer

  my name is ravi

  iam sas programer

  iam good in sas

  based on this i want out put like this

  positionid name

  1 sas

  1 sas

  0 sas

  5 sas

  13 sas

  and i try this like select charindex('sas',name)from table .that time i find only postion of sas string but i want display name sas and that position

  how to solve this in sql server.plz tell me the query

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  April 30, 2013 at 8:55 am

  #1611279

  Like this?

  select name, charindex('sas',name)from table

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  April 30, 2013 at 8:56 am

  #1611280

  or this?

  select charindex('sas',name), 'sas' from table

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/