Access and !=

[Jeff Thies]

I'm not sure how to write this so Access will understand it:

SELECT * FROM some_table WHERE some_field != ''

What is the secret?

Jeff

[Aaron Bertrand - MVP]

WHERE some_column <> ''

WHERE LEN(some_column) > 0

Also, don't use SELECT *, name your columns...




"Jeff Thies" <cyberjeff@sprintmail.com> wrote in message
news:3F306319.1E7E4272@sprintmail.com...

> I'm not sure how to write this so Access will understand it:
>
> SELECT * FROM some_table WHERE some_field != ''
>
> What is the secret?
>
> Jeff

[Jeff Thies]

As always, Thanks.

Aaron Bertrand - MVP wrote:

>
> WHERE some_column <> ''
>
> WHERE LEN(some_column) > 0

Will that also pick up nulls?

>
> Also, don't use SELECT *, name your columns...

Good point. Bad example code.

Cheers,
Jeff

>
> "Jeff Thies" <cyberjeff@sprintmail.com> wrote in message
> news:3F306319.1E7E4272@sprintmail.com...

> > I'm not sure how to write this so Access will understand it:
> >
> > SELECT * FROM some_table WHERE some_field != ''
> >
> > What is the secret?
> >
> > Jeff

[Ken Schaefer]

Access, and most other relational databases use a language called SQL
(Structured Query Language). You may find it helpful to bookmark a webpage
that contains a reference list of clauses and operators.

WHERE field <> condition

Cheers
Ken

"Jeff Thies" <cyberjeff@sprintmail.com> wrote in message
news:3F306319.1E7E4272@sprintmail.com...
: I'm not sure how to write this so Access will understand it:
:
: SELECT * FROM some_table WHERE some_field != ''
:
: What is the secret?
:
: Jeff

[Bit My Bubbles]

Nulls:

where blablah is not null


"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
news:%23t9FdW8WDHA.2312@TK2MSFTNGP10.phx.gbl...

> Access, and most other relational databases use a language called SQL
> (Structured Query Language). You may find it helpful to bookmark a webpage
> that contains a reference list of clauses and operators.
>
> WHERE field <> condition
>
> Cheers
> Ken
>
> "Jeff Thies" <cyberjeff@sprintmail.com> wrote in message
> news:3F306319.1E7E4272@sprintmail.com...
> : I'm not sure how to write this so Access will understand it:
> :
> : SELECT * FROM some_table WHERE some_field != ''
> :
> : What is the secret?
> :
> : Jeff
>
>