Question: I don't know what this is called, but it is something like syncing android application and a Web server. Examples are RSS Feeds and Weather Forecast

Does anyone know the concept behind developing application? I mean how do you sync the Android phone with a web server. Is there any programming needed in the server side and the client side(Android)

Are there any programming books that tackles this subject? Thanks.

Answer: 
Try this:

```
SELECT myCol 
FROM myTable 
WHERE SUBSTRING(myCol, 1 , 1) >= 'A' 
AND SUBSTRING(myCol, 1 , 1) <= 'Z' 
AND SUBSTRING(myCol, 2 , 1) >= 'A' 
AND SUBSTRING(myCol, 2 , 1) <= 'Z' 
AND SUBSTRING(myCol, 3 , 1) >= '0' 
AND SUBSTRING(myCol, 3 , 1) <= '9'

```
```
SELECT myCol 
FROM   myTable 
WHERE  ( myCol LIKE '12X%' OR myCol LIKE '34Y%' ) 
AND    myCol NOT LIKE '34YY%'

```

Rough example, but should help you figure the problem out. Can't help more since your example isn't that precise.