<div>
<br />
simpler one would be:<br />
<br />
WHERE myCol LIKE '%)*'<br />

</div>



simpler one would be:

WHERE myCol LIKE '%)*'


<div>
@pg_vinod: your solution will find all rows where the field ends in )* including those that do not match the search criteria, such as &quot;(abc)*&quot;<br />
<br />
My solution is not 100% sufficient because it will also find columns where date is invalid. To check that something really is a date is a whole chapter in itself.
</div>


@pg_vinod: your solution will find all rows where the field ends in )* including those that do not match the search criteria, such as "(abc)*"

My solution is not 100% sufficient because it will also find columns where date is invalid. To check that something really is a date is a whole chapter in itself.

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I have a column in sybase table which has column values in this format<br />
<br />
ABC TECH (11/09/09)*<br />
CDE INC<br />
FEG SYNC (11/09/10)*<br />
<br />
I need to find all the records which have date in parenthesis followed by *. Please advise
</div>
</div>


I have a column in sybase table which has column values in this format

ABC TECH (11/09/09)*
CDE INC
FEG SYNC (11/09/10)*

I need to find all the records which have date in parenthesis followed by *. Please advise

Sybase searching for date

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.