Try ltrim($Device_Name); before running query Bartek Pawlik ----- Original Message ----- From: Stephan Nimtz <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 06, 2001 10:21 AM Subject: [PHP-DB] mssql update adds blank to record > can anyone help me ??? > > the command: > > mssql_query("UPDATE IP_Host > SET Device_Name='$Device_Name', > Device_Owner='$Device_Owner', > Description='$Description' > WHERE ID=$ID"); > > creates always a blank character at the first position of the record. > > how can i get rid of that ??? > > thx stephan > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- OnetKomunikator - porozumiesz sie z innymi [ http://ok.onet.pl/instaluj.html ] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]