Many thanks people, I'll give all the suggestions a try

many thanks for the quick responce, I'll give that a try, although I was told to obtain the results I want I should really use JOIN, something I haven't even...

Many thanks Michelle, I found that very helpfull

my appologies everyone, I've found my problem.. I was using a variable instead of 'cde' and I hadn't set the length

I've just discovered how to do it, I've posted what I've found below

set @sDayofWeek = datename(weekday,'10/11/2005') -- returns "Tuesday"

set @sDayofWeek = datename(day,'10/11/2005') -- returns "10"

set @sDayofWeek = datename(month,'10/11/2005') -- returns...

Oop's sorry, slight mistake, the solution I posted didn't return the value in @status

Below is the working version

declare @status nvarchar

declare @sDate1 varchar(10)

declare @CMD Nvarchar(100)

declare @ColName as...

many thanks for the reply, I've managed to achieve what I wanted thanks to you by modifying your example, I've posted below the code I'm using

declare @status varchar

declare...

RGR's, can you explain what you mean by "Not gonna stand having someone blatantly lie to me and expect me to be nice about it."

hear, hear

what do you mean by prone to sql injection attacks ?

I've actually got it working. At Last !!!

here's what I used :-

CREATE  PROCEDURE spSaveDaysArea  @sName as VarChar(200),@sArea as VarChar(100), @sDate1 as VarChar(100)

AS

declare @sql as varchar(5000)

set @sql...

I'm trying to update a database using VB and passing the name of the field and the data I want to put in that particular field, if that makes sence,...

I did actually read the link before posting my question on the forum, I couldn't see anything that could help me, I'm just starting out using an SQL server and...

because I'm using a vairable for the field name

Function Copy_Table_From_Sql_Server(ByVal NewTable As String, ByVal ExistingTable As String, ByVal LocalDb As Database) As Boolean

On Error GoTo ErrHandler

CopyTable:  'try and copy before deleting the existing table

            'just incase it doesn't...