Hi Plater
SUBSTRING worked great, thank you again
I V
Last Activity: Aug 9 '07, 12:43 PM
Joined: May 22 '07
Location:
-
Thank you Plater, but I got this error
'SUBSTR' is not a recognized built-in function name !!Leave a comment:
-
Problem in displaying and using date as criteria
Hello,
I have nvarchar field in SQL server 2000 database like yyyymmdd
I wanted to change it to datetime to use it in my criteria and separated to use it in three TextBoxes, one for dd, another one for mm and the last one for yyyy.
I used the convert function as below
SQL1 = SQL1 + " where convert(datetim e,EMP_SENIORITY _DT_G) = '" + TextBox2.Text + "' ";
First...
No activity results to display
Leave a comment: