August 29, 2008 08:06pm pdt

1. jpaulino 810,495
2. TheLearn... 726,583
3. Idle_Mind 429,341
4. Sancler 373,508
5. VBRocks 369,999
6. PaulHews 353,757
7. Dhaest 322,304
8. Fernando... 319,385
9. jaime_oliv... 312,069
10. jcoehoorn 260,456
11. emoreau 243,517
12. webtubbs 235,492
13. angelIII 191,312
14. vb_jonas 183,591
15. GreenGho... 166,611
16. rachitkohli 156,236
17. mlmcc 132,609
18. graye 126,480
19. armoghan 106,215
20. planocz 98,038
21. TimCottee 96,932
22. ZachSmith 93,895
23. AkisC 85,105
24. samtran0... 71,944
25. ee_rlee 71,420

1. TheLearn... 4,181,066
2. Idle_Mind 3,506,493
3. Sancler 2,354,988
4. Fernando... 2,069,835
5. jpaulino 1,159,862
6. RonaldBie... 1,159,695
7. emoreau 1,058,840
8. VBRocks 925,180
9. iboutchkine 814,529
10. Chaosian 674,034
11. angelIII 658,019
12. webtubbs 657,913
13. PaulHews 640,798
14. planocz 634,195
15. graye 618,360
16. Dhaest 602,499
17. arif_eqbal 596,164
18. gregoryyo... 585,515
19. jaime_oliv... 542,670
20. ZeonFlash 486,195
21. vbturbo 477,858
22. AlexFM 473,611
23. BriCrowe 435,117
24. ptakja 389,723
25. amyhxu 386,998

01.10.2008 at 12:53AM PST, ID: 23071951

	[x] Attachment Details

Checking Empty String of Access Table in SQL Statement.

Asked by emi_sastra in Microsoft Visual Basic.Net, Microsoft Access Database

Tags: Microsoft, Visual Basic, Visual Basic 2005

Hi,

I have an access table.
Below code works.

SELECT * FROM TableName WHERE GroupId <> "" (double ").

Below does not work?

SELECT * FROM TableName WHERE GroupId = "" (double ").

The GroupId at design time I set it to "" (double "" - Empty String).

Please help.

Thank you.

Start Free Trial

Keywords: Checking Empty String of Access Tabl…

	Title
1	changing nulls to empty string in dts
2	Convert NULL to EMPTY string
3	Update with null instead of empty string
4	SQL Need to check if null or empty stri…
5	sql: i need a logic that would allow m…
6	MS Access - how to convert null valu…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Checking Empty String of Access Table in SQL Statement.

Asked by emi_sastra in Microsoft Visual Basic.Net, Microsoft Access Database

Tags: Microsoft, Visual Basic, Visual Basic 2005

About this solution