Archives of the TeradataForum

Message Posted: Tue, 20 Sep 2005 @ 09:44:39 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Have you tried substring?

as in

     select *
     from my_data
     where substring (col1 from 1 for 1) between 'a' and 'z'

?

If you use like, you would probably need to do something like this:

     select *
     from my_data
     where col1 like 'a%' or
         col1 like 'b%' or
         col1 like 'c%' or
     etc
     so on
     and so forth
        ... or
        col1 like 'z%'

I know which one I would prefer to use.

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>