FreeTDS Development Group

["Winkless, Geoff" <geoff.winkless AT pera.com>]

I wrote:
> However the whole point was that although there may well be 
> -better- ways of
> checking a year/date combination, the LIKE '2001-03%' example 
> shown -should-
> work, and it'd be interesting to see why it doesn't.

And of course Simon Matthews hinted at this: force the CONVERT() function to
use the ISO date format using the optional STYLE parameter (position 3)

so

WHERE CONVERT (varchar(20), column_name, 121) LIKE '%2001-03-%' 

works exactly as expected (although of course is not recommended for the
reasons already discussed!)

Further values for the STYLE parameter can be found in the TSQL
documentation.

Geoff