SQL Experts - Access Question
Deebaser
on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
Title shamelessly stolen.
Im trying to simplify a report so that I can just run it out of access. One line of code is giving me problems.
i.varchar_column like ("%" + CONVERT(varchar(20), lol.int_column) + "%")
How can I convert this into access-approved sql?
Im trying to simplify a report so that I can just run it out of access. One line of code is giving me problems.
i.varchar_column like ("%" + CONVERT(varchar(20), lol.int_column) + "%")
How can I convert this into access-approved sql?
Deebaser on
0
Posts
Just get rid of the Convert part so it just reads
("%" & lol.int_column & "%")
Access (2003, not sure on 2007) doesn't do Convert. If the above doesn't work:
("%" & str(lol.int_column) & "%")
I've also edited this post way too many times.