SELECT statement - return everything before Mits

[jasonhuibers]

I have a record value of:

TekMits

I want the result to be everything before Mits. So the record returned would be Tek.. How can I do this in a SELECT statement?

 

[Turkbear]

Select substr(Table.field,1,3)
from Table



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jasonhuibers]

Sorry only thing is I never know what charcters are before the Mits...

 

[stefanhei]

There may be a more elegant solution but try this:

SELECT substr(fieldname,1,length(fieldname)-instr(fieldname,'Mits'))
  FROM tablename

 

[stefanhei]

Ahm, sorry, the above doesn't fit your requirement. This should do:

SELECT substr(fieldname,1,instr(fieldname,'Mits')-1)
  FROM tablename

 

[SantaMufasa]

Does every row contain the string, "Mits"? If not, the above code will print out nothing for the rows that do not contain "Mits". Is that what you want?

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.