Like task

Alexander_5 · July 14th, 2007, 03:52 AM

Hi Every One

I am web developer.
I am new in this forum.
Can anyone help me to solve this task
I want write sql query which should select rows from db which contains
some field which value contains only five "a" symbol for e.g.
Using only '%' and '_' in Like command without any regular expression

best Alik

:)

Alik

happygv · July 18th, 2007, 07:31 AM

Is this what you are looking for?

Code:

Select column_name from tablename where column_name like 'aaaaa%'

_________________________
- Vijay G
Strive for Perfection

Alexander_5 · July 19th, 2007, 07:12 AM

[quote]Originally posted by happygv
Is this what you are looking for?

Code:

Select column_name from tablename where column_name like 'aaaaa%'

No i mean this kind of words "addddabbbbacccakkk"

Alik