SQL Questions

<i><b>Originally posted by : Robert Megliorino (rmeglior@alleghenytechnologies.com)</b></i><br /><br />Hello: I'm trying to do two things:<br /><br />1) How can I have a text field with more than 255 characters? I tried memo, but the ASP component returns an error when I select it. I also want the field searchable(if possiable).<br /><br />2) Also: I'm trying to select a time out of the DB. The field is a DATETIME field with a default value of NOW() I'm using:<br /><br />mydate = now()<br /><br />SELECT * FROM mytable WHERE tabledate = '"& mydate &"'.<br /><br />It never finds any records. I've tried it with the LIKE statement and everything.<br /><br /> <br /><br />Any ideas? Thanks a bunch!!!<br />