syntax in interger and string in SQL

[angelagke]

INSERT titles (title, cost) VALUES ('testing', '35') why SQL statement above can work? since the 35 is interger and not a string, so shount not be include '' for interger value.... :confused: angela

[albCode]

Sure it works u can add values as integer too (for integer filed) ur example works as this: INSERT titles (title, cost) VALUES ('testing', 35)

[Eric Dahlvang]

Automatic data type conversion. ---------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters

[angelagke]

i know, because i test before.. but i don't know why i can work....:| angela

[angelagke]

oic, no wonder it works lah;) thanks ya..:) angela