HI All,

I was wondering if anyone had found anything on this?

I've been looking but can't see to find anything to read up 🙁

I'm sure I read somewhere a year ago...

Thanks Michael E 🙂

Most my mates same the same thing, I'm working on it 😀

Michael J, please could you give me an example?

thanks

Chris

HEre are two examples of the fun side of it:

SELECT REPLACE(0x5768617473206e6f742066756e2061626f75742074686973,'Check This','Out')

print replace(0x2027202729,0x20,'print replace(0x2027202729,0x20,')

😎

Sorry it should have read

SUBSTRING(COl3,2,LEN(Col3)-2)

Couldn't you just update the column after the data insert by saying

UPDATE Mytable

SET Col3 = SUBSTRING(Col3 ,2,LEN(@Col3 )-2)

This will remove the outer two quotes provided they are always...

WEll you need to remember that you shouldn't use SELECT * so you should return the book columns in a food query

Other thing is to maybe create a ProductsBook and ProductsFood table?

What do people think of this?

True about the pivot, but even though the thread is under 2005 I think the guy is using 2000

Good call Jeff,

This may not work if the DateFirst changes

SELECT DATEADD(DAY,1-DATEPART(weekday,dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,@dte)+1, 0))),dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,@dte)+1, 0)))

still working on that part.

Thanks

Chris

Well you need to change the syntax for the name of the textbox and the form that it belongs to ...

The reason it works is because [TextBoxValue] = "" will...

UPDATE [T]

SET [T].HomePhone = .Phone

FROM EeTemp_T [T]

INNER JOIN EeUpdates_T

ON .[EE_ID] = [T].[EE_ID]

WHERE .Phone NOT IN (select HomePhone from [EeTemp_T])

DELETE

FROM [EeUpdates_T]

WHERE .Phone IN (select HomePhone from [EeTemp_T])

YOu could...

mmm

OK what is the Temp table for?

You should beable to simply run an update statement followed by the Delete statement with not loops or if statements on all the rows...

HI there,

Please could you post the query that you have so far, so that we can point you in the right direction

thanks

Chris

Have you tried converting your int's to decimals?

HI,

Have you tried something like this in your query

SELECT *

FROM Mytable

WHERE Col1 = [TextboxValue] or [TextboxValue]= ''

That way if the text box is empty then everything comes back