---
title: "SELECT * FROM ... WHERE strText >= antal bokstäver"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/105422-select-from-where-strtext-antal-bokstäver"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Eclipse"
published: "2004-06-10T18:46:28.000Z"
updated: "2004-06-10T18:52:33.000Z"
replies: 2
views: 210
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/105422-select-from-where-strtext-antal-bokstäver"
---

# SELECT * FROM ... WHERE strText >= antal bokstäver

## #1 — Eclipse, 2004-06-10T18:46Z

Hur skriver jag?

SQL = "SELECT TOP 20 intID, dteCreated, strName, strText " \_
  & " FROM \[news\] WHERE strText \>= **200 tecken** ORDER BY dteCreated DESC;"

Permalänk: https://www.webforum.nu/p/105422

## #2 — LarsG, 2004-06-10T18:48Z

Access?

```
SELECT TOP 20 intID, dteCreated, strName, strText 
FROM news 
WHERE len(strText) >= 200 
ORDER BY dteCreated DESC
```

Permalänk: https://www.webforum.nu/p/1367157

## #3 — Eclipse, 2004-06-10T18:52Z

Fortfarande Access, sorry! Tack.

Permalänk: https://www.webforum.nu/p/1367160

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/105422-select-from-where-strtext-antal-bokstäver