strDetail = CHRTRAN(strDetail, ['], ['']) * Now your string looks like this 'Here is an ''example'' of what I mean'>Hi,
>Dim cmdUpdateProp As New ADODB.Command >Dim strSQL As String > >With cmdUpdateProp > .ActiveConnection = mconnDatabase > .CommandTimeout = 60 > .CommandType = adCmdText >End With > >strSQL = "EXEC sp_updateextendedproperty 'lds_Comment', '" & strDetail > & "', 'user', dbo, 'table', '" & mstrTable & "', null, null" > >cmdUpdateProp.CommandText = strSQL >cmdUpdateProp.Execute > >>
> > "Here is an 'example' of what I mean". > >>
> >strSQL = "EXEC sp_updateextendedproperty 'lds_Comment', #" & strDetail > & "#, 'user', dbo, 'table', #" & mstrTable & "#, null, null" > >>