Forums

This topic is locked

HELP declare Stored Procedure VALUES

Posted 11 Sep 2002 01:04:00
1
has voted
11 Sep 2002 01:04:00 ilan co posted:
I NEED HALP WITH SQL
MY DATE TIME FORMT IS NOT OK I DONT GET ANY OUTPUT FROM VALUES
<pre id=code><font face=courier size=2 id=code> </font id=code></pre id=code>
DECLARE @dayA [varchar](2)
DECLARE @monthA [varchar](2)
DECLARE @yearA [varchar](4)
Set @dayA ='10'
Set @monthA = '01'
Set @yearA = '2002'
SELECT id, Fname, mhlka, fld1, fld2, fld3, fld4, fld5, na
FROM dbo.Sn
where FLD1 LIKE CONVERT(char(10),'@dayA +/ + @monthA + / + @yearA',103)

<pre id=code><font face=courier size=2 id=code> </font id=code></pre id=code>
THNKS

Reply to this topic