Left, Right function?? 1

[Zonie32]

I have a field called Plan. It list several different Plan names, but I just want to extract all PLANS that have the first words as SINGLE DED and then the number 70 in the same string.

SINGLE DED FAM 2500/70 RX 4

this is a sample: it is all one string. I tried using the Right and Left function, but was not getting anywhere. Can anyone help me?

 

[r937]

select Plan
  from yourtable
 where left(Plan,11) = 'SINGLE DED '
   and Plan like '*70*'

rudy

http://r937.com/

SQL Consulting

 

[ALEKSJAY]

or you can combine what rudy said in one line:
"select plan form table where plan like 'SINGLE DED*70*'

 

[r937]

doh! so obvious

star for you, aleksjay

rudy

http://r937.com/

SQL Consulting