$mystreet=$_; $dbh2->do("INSERT INTO PerlTest (Postcode,Street,streetCount) VALUES (?,?,?)", undef, '', $mystreet, 0); #### CREATE TABLE [dbo].[PerlTest]( [Postcode] [varchar](50) NULL, [Street] [varchar](50) NULL, [streetCount] [int] NULL ) ON [PRIMARY]