|
View previous topic :: View next topic
|
| Author |
Message |
sunojsm
Warnings : 1
New User
Joined: 21 Jun 2004
Posts: 33
Location: Andorra
|
|
|
|
I have to extract some records from around 400,000 records.
The condition is like :
the records which have National Characters only we need to retreive.
This record is 8 char field.The national characters can be at any position.
I tried LIKE statement which I got the result but the query is somewhat very long one and affecting the performance.
Could you please provide me simple query or any idea for this or any specific command is there.
Thanks
Sunoj |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
You could read the rows into some program code and parse the 8 bytes for the National Characters you are looking for.
Some things are better accomplished outside of SQL.
It might help if you clarify this
| Quote: |
somewhat very long one and affecting the performance.
|
What is "very long". What performance is being affected? |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| sunojsm wrote: |
I have to extract some records from around 400,000 records.
The condition is like :
the records which have National Characters only we need to retreive.
This record is 8 char field.The national characters can be at any position.
I tried LIKE statement which I got the result but the query is somewhat very long one and affecting the performance.
Could you please provide me simple query or any idea for this or any specific command is there.
Thanks
Sunoj |
Instead of using LIKE try POSSTR or since the field is only 8 characters use SUBSTR to check each of the eight characters. |
|
| Back to top |
|
|
|
|
