How to insert a text field converting to time field SQL Server 7.0

<i><b>Originally posted by : Asli (vatansev@yahoo.com)</b></i><br />Hi Everybody,<br /><br />I get some time fields fromthe user in may ASP program but I can not convert this text to datetime in SQL Server .<br /><br />I tried the cast and convert functions but not working.<br /><br />Do u have any idea ?<br /><br />Thanks !<br /><br />Asli<br />

no

Convert(datetime, MyValue, 101)