<div>
BigSchmuh,<br />
Thank you for your reponse. &nbsp;Unfortunately, POSSTR would make it even more complicated. &nbsp;DB2 should implement this feature in their future releases.<br />
<br />
I'm planning on deleting this topic, since there is no solution....
</div>


<div>
Well, I don't care of the points but the fact that there is no solution to search for regular expression is a good information...
</div>


<div>
<div class="content wysiwyg-content">
Hi!<br />
In SQL 2K server, I am able to use [0-9] to indicate that I am limiting a character within a column to be a number, for example LIKE '[0-9][0-9]ABCD%'. &nbsp;I have been trying to accomplish the same in DB2 environment and could not find a single reference guiding me how to do it. &nbsp;Any suggestions how to overcome this?<br />
<br />
Thanks!
</div>
</div>


Hi!
In SQL 2K server, I am able to use [0-9] to indicate that I am limiting a character within a column to be a number, for example LIKE '[0-9][0-9]ABCD%'.  I have been trying to accomplish the same in DB2 environment and could not find a single reference guiding me how to do it.  Any suggestions how to overcome this?

Thanks!

BigSchmuh,
Thank you for your reponse.  Unfortunately, POSSTR would make it even more complicated.  DB2 should implement this feature in their future releases.

I&#39;m planning on deleting this topic, since there is no solution....

Well, I don&#39;t care of the points but the fact that there is no solution to search for regular expression is a good information...

Wild Cards in DB2

Hi!
In SQL 2K server, I am able to use [0-9] to indicate that I am limiting a character within a column to be a number, for example LIKE &#39;[0-9][0-9]ABCD%&#39;.  I have been trying to accomplish the same in DB2 environment and could not find a single reference guiding me how to do it.  Any suggestions how to overcome this?

Thanks!

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.