tag:blogger.com,1999:blog-6711727.post-78058818436517498472008-02-21T18:42:00.010-06:002008-03-07T12:10:48.310-06:00CASE: This way (3) NULLs get put in tbl if data is blank.<pre>command = New SqlCommand("INSERT INTO tblFoo (UIAcctNum, WorkZip, CheckRouteDesc, Agency, Division, RUN, Rpt_Unit_RUNDesc, StartDate,EndDate ,CheckRouteCode, Rpt_Unit_RUNDesc__old,NAICS) " & _
" VALUES (@UIAcctNum, @WorkZip, @CheckRouteDesc, @Agency, @Division, @RUN, " & _
"CASE WHEN ltrim(@Rpt_Unit_RUNDesc) = '' THEN NULL ELSE @Rpt_Unit_RUNDesc END, " & _
"@StartDate, " & _
"CASE WHEN ltrim(@EndDate) = '' THEN NULL ELSE @EndDate END, " & _
"@CheckRouteCode, " & _
"CASE WHEN ltrim(@Rpt_Unit_RUNDesc__old) = '' THEN NULL ELSE @Rpt_Unit_RUNDesc__old END, " & _
" CASE WHEN ltrim(@NAICS) = '' THEN NULL ELSE @NAICS END)", connection) ' This way (3) NULLs get put in tbl if data is blank.</pre><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-4039287786711000";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text_image";
google_ad_channel ="";
google_color_border = "DEE7EC";
google_color_bg = "FFFFFF";
google_color_link = "0066FF";
google_color_url = "0066FF";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></div>programmabilitieshttp://www.blogger.com/profile/06938880405055923257noreply@blogger.com