You can change SQL syntax in Command object according to your value:
DataEnvironment1.Command1.CommandText = "SELECT * FROM SomeTable WHERE SomeField = " & Trim(Str(SomeValue))
Plamen Ivanov MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000) MCSD (VB 6.0/SQL Server 2000) br> VB (.NET) - what other language do you need in the whole Universe?...