deal with char

• najeeb selk

  SSC Enthusiast

  Points: 103

  More actions

  March 31, 2006 at 6:20 am

  #111604

  Hi

  i want to have one char from filed with data (nvarchar(50))

  how can i do that;

   

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  March 31, 2006 at 6:32 am

  #630071

  An example please - of data and char to be extracted...

  for instance if you're looking for 's' in a string, you'd do something like this:

  declare @string nvarchar(50)

  set @string = 'abcdefghijklmnopqrstuvwxyz'

  select substring(@string, charindex('s', @string), 1)

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• najeeb selk

  SSC Enthusiast

  Points: 103

  More actions

  March 31, 2006 at 6:44 am

  #630080

  ok

  first filed @cul1 ='000000011111000'

  i want to extract the number of  first appear of '1' to fill it in another column

  thanks 

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  March 31, 2006 at 7:16 am

  #630091

  If I understand you correctly, you want the position of the first occurence of '1' in your string...if so, then..

  declare @string nvarchar(50)

  declare @position tinyInt

  set @string = '000000011111000'

  set @position = charindex('1', @string)

  print @position

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**