How to use wild Char for selecting a field using WHERE

• Sisir Kumar De

  SSC Enthusiast

  Points: 124

  More actions

  September 25, 2007 at 12:13 am

  #175146

  Hi,

  I am a newbie. can you tell me how to display the data from a table by matching a protion of the field data using WHERE. e.g I want to see all rows of a table "Employee" having a column "name" (25 Char) whose 2nd 3rd and 4th char matches with say "abc". What I have to do for replacing those character with "xyz" in the table. Also intimate how to generate new Index for a table whose data (rows) are not in sequential order as that of the table from where the data is imported (from another server).  

• Jo Pattyn

  SSC-Dedicated

  Points: 32430

  More actions

  September 25, 2007 at 2:47 am

  #735926

  You can find those with

  update ...

  set myfield=left(myfield,1)+'xyz'+right(myfield,len(myfield)-4)

  where myfield like '_abc%'

  %	Any string of zero or more characters.	WHERE title LIKE '%computer%' finds all book titles with the word 'computer' anywhere in the book title.
  _ (underscore)	Any single character.	WHERE au_fname LIKE '_ean' finds all four-letter first names that end with ean (Dean, Sean, and so on).
  [ ]	Any single character within the specified range ([a-f]) or set ([abcdef]).	WHERE au_lname LIKE '[C-P]arsen' finds author last names ending with arsen and beginning with any single character between C and P, for example Carsen, Larsen, Karsen, and so on.
  [^]	Any single character not within the specified range ([^a-f]) or set ([^abcdef]).	WHERE au_lname LIKE 'de[^l]%' all author last names beginning with de and where the following letter is not l.