SQL Server UPDATETEXT

[iccsi]

I use SQL Server as backend and need use UPDATETEXT to updtae my nText field in SQL server.

I just wonder does ColdFusion take care for this from ColdFusion client side or I need sprecific using same SQL code for SQL Server backend.

Your help and information is great appreciated,

iccsi

[Owainnorth]

All CF does is pass your query string to the database engine, along with any bind variables. Therefore any syntax that is valid in the database will run.