Other CHAR SQL function

1. Usage of CHAR to get CHAR of first letter in Company Name

SQL Server Query 1

            
 SELECT CustomerID, CompanyName, CHAR(ASCII(LEFT(CompanyName, 1))) AS FirstLetterCharacter FROM Customers;

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("CustomerID", "CompanyName")  

     .Column(new CHAR(new ASCII(new LEFT(new Column("CompanyName"), 1))), "FirstLetterCharacter")  

     .From("Customers")  

     .Build();

Query build by SqlQueryBuilder 1

            
SELECT CustomerID,
       CompanyName,
       CHAR(ASCII(LEFT(CompanyName, @pMAIN_2507192103021765450))) AS FirstLetterCharacter
FROM Customers;

Parameters (If used)

Name	Value
@pMAIN_2507192103021765450	1

Query Results 1:

	CustomerID	CompanyName	FirstLetterCharacter
1	ALFKI	Alfreds Futterkiste	A
2	ANATR	Ana Trujillo Emparedados y helados	A
3	ANTON	Antonio Moreno Taquería	A
4	AROUT	Around the Horn	A
5	BERGS	Berglunds snabbköp	B
6	BLAUS	Blauer See Delikatessen	B
7	BLONP	Blondesddsl père et fils	B
8	BOLID	Bólido Comidas preparadas	B
9	BONAP	Bon app'	B
10	BOTTM	Bottom-Dollar Markets	B
11	BSBEV	B's Beverages	B
12	CACTU	Cactus Comidas para llevar	C
13	CENTC	Centro comercial Moctezuma	C
14	CHOPS	Chop-suey Chinese	C
15	COMMI	Comércio Mineiro	C
16	CONSH	Consolidated Holdings	C
17	WANDK	Die Wandernde Kuh	D
18	DRACD	Drachenblut Delikatessen	D
19	DUMON	Du monde entier	D
20	EASTC	Eastern Connection	E
21	ERNSH	Ernst Handel	E
22	FAMIA	Familia Arquibaldo	F
23	FISSA	FISSA Fabrica Inter. Salchichas S.A.	F
24	FOLIG	Folies gourmandes	F
25	FOLKO	Folk och fä HB	F
26	FRANR	France restauration	F
27	FRANS	Franchi S.p.A.	F
28	FRANK	Frankenversand	F
29	FURIB	Furia Bacalhau e Frutos do Mar	F
30	GALED	Galería del gastrónomo	G
31	GODOS	Godos Cocina Típica	G
32	GOURL	Gourmet Lanchonetes	G
33	GREAL	Great Lakes Food Market	G
34	GROSR	GROSELLA-Restaurante	G
35	HANAR	Hanari Carnes	H
36	HILAA	HILARION-Abastos	H
37	HUNGC	Hungry Coyote Import Store	H
38	HUNGO	Hungry Owl All-Night Grocers	H
39	ISLAT	Island Trading	I
40	KOENE	Königlich Essen	K
41	LACOR	La corne d'abondance	L
42	LAMAI	La maison d'Asie	L
43	LAUGB	Laughing Bacchus Wine Cellars	L
44	LAZYK	Lazy K Kountry Store	L
45	LEHMS	Lehmanns Marktstand	L
46	LETSS	Let's Stop N Shop	L
47	LILAS	LILA-Supermercado	L
48	LINOD	LINO-Delicateses	L
49	LONEP	Lonesome Pine Restaurant	L
50	MAGAA	Magazzini Alimentari Riuniti	M
51	MAISD	Maison Dewey	M
52	MEREP	Mère Paillarde	M
53	MORGK	Morgenstern Gesundkost	M
54	NORTS	North/South	N
55	OCEAN	Océano Atlántico Ltda.	O
56	OLDWO	Old World Delicatessen	O
57	OTTIK	Ottilies Käseladen	O
58	PARIS	Paris spécialités	P
59	PERIC	Pericles Comidas clásicas	P
60	PICCO	Piccolo und mehr	P
61	PRINI	Princesa Isabel Vinhos	P
62	QUEDE	Que Delícia	Q
63	QUEEN	Queen Cozinha	Q
64	QUICK	QUICK-Stop	Q
65	RANCH	Rancho grande	R
66	RATTC	Rattlesnake Canyon Grocery	R
67	REGGC	Reggiani Caseifici	R
68	RICAR	Ricardo Adocicados	R
69	RICSU	Richter Supermarkt	R
70	ROMEY	Romero y tomillo	R
71	SANTG	Santé Gourmet	S
72	SAVEA	Save-a-lot Markets	S
73	SEVES	Seven Seas Imports	S
74	SIMOB	Simons bistro	S
75	SPECD	Spécialités du monde	S
76	SPLIR	Split Rail Beer & Ale	S
77	SUPRD	Suprêmes délices	S
78	THEBI	The Big Cheese	T
79	THECR	The Cracker Box	T
80	TOMSP	Toms Spezialitäten	T
81	TORTU	Tortuga Restaurante	T
82	TRADH	Tradição Hipermercados	T
83	TRAIH	Trail's Head Gourmet Provisioners	T
84	VAFFE	Vaffeljernet	V
85	VICTE	Victuailles en stock	V
86	VINET	Vins et alcools Chevalier	V
87	WARTH	Wartian Herkku	W
88	WELLI	Wellington Importadora	W
89	WHITC	White Clover Markets	W
90	WILMK	Wilman Kala	W
91	WOLZA	Wolski Zajazd	W

2. Usage of CHAR

SQL Server Query 2

            
 SELECT OrderID, CASE WHEN Quantity > 10 THEN CHAR(88) ELSE CHAR(79) END AS QuantityIndicator FROM [Order Details];

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  

     .Select().Column("OrderID", "OrderID")  

     .Column(new CASE()  

         .When(new Column("Quantity").GreaterThan(10))  

         .Then(new CHAR(88))  

         .Else(new CHAR(79)), "QuantityIndicator")  

     .From("[Order Details]")  

     .Build();

Query build by SqlQueryBuilder 2

            
SELECT OrderID AS OrderID,
       CASE WHEN Quantity > @pMAIN_2507192103021788590 THEN CHAR(@pMAIN_2507192103021788591) ELSE CHAR(@pMAIN_2507192103021788592) END AS QuantityIndicator
FROM [Order Details];

Parameters (If used)

Name	Value
@pMAIN_2507192103021788590	10
@pMAIN_2507192103021788591	88
@pMAIN_2507192103021788592	79

Query Results 2:

	OrderID	QuantityIndicator
1	10248	X
2	10248	O
3	10248	O
4	10249	O
5	10249	X
6	10250	O
7	10250	X
8	10250	X
9	10251	O
10	10251	X
11	10251	X
12	10252	X
13	10252	X
14	10252	X
15	10253	X
16	10253	X
17	10253	X
18	10254	X
19	10254	X
20	10254	X
21	10255	X
22	10255	X
23	10255	X
24	10255	X
25	10256	X
26	10256	X
27	10257	X
28	10257	O
29	10257	X
30	10258	X
31	10258	X
32	10258	O
33	10259	O
34	10259	O
35	10260	X
36	10260	X
37	10260	X
38	10260	X
39	10261	X
40	10261	X
41	10262	X
42	10262	X
43	10262	O
44	10263	X
45	10263	X
46	10263	X
47	10263	X
48	10264	X
49	10264	X
50	10265	X
51	10265	X
52	10266	X
53	10267	X
54	10267	X
55	10267	X
56	10268	O
57	10268	O
58	10269	X
59	10269	X
60	10270	X
61	10270	X
62	10271	X
63	10272	O
64	10272	X
65	10272	X
66	10273	X
67	10273	X
68	10273	X
69	10273	X
70	10273	X
71	10274	X
72	10274	O
73	10275	X
74	10275	O
75	10276	X
76	10276	O
77	10277	X
78	10277	X
79	10278	X
80	10278	X
81	10278	O
82	10278	X
83	10279	X
84	10280	X
85	10280	X
86	10280	X
87	10281	O
88	10281	O
89	10281	O
90	10282	O
91	10282	O
92	10283	X
93	10283	X
94	10283	X
95	10283	O
96	10284	X
97	10284	X
98	10284	X
99	10284	O
100	10285	X
101	10285	X
102	10285	X
103	10286	X
104	10286	X
105	10287	X
106	10287	X
107	10287	X
108	10288	O
109	10288	O
110	10289	X
111	10289	O
112	10290	X
113	10290	X
114	10290	X
115	10290	O
116	10291	X
117	10291	X
118	10291	O
119	10292	X
120	10293	X
121	10293	O
122	10293	O
123	10293	O
124	10294	X
125	10294	X
126	10294	X
127	10294	X
128	10294	O
129	10295	O
130	10296	X
131	10296	X
132	10296	X
133	10297	X
134	10297	X
135	10298	X
136	10298	X
137	10298	X
138	10298	X
139	10299	X
140	10299	X
141	10300	X
142	10300	X
143	10301	O
144	10301	X
145	10302	X
146	10302	X
147	10302	X
148	10303	X
149	10303	X
150	10303	X
151	10304	X
152	10304	O
153	10304	O
154	10305	X
155	10305	X
156	10305	X
157	10306	O
158	10306	O
159	10306	O
160	10307	O
161	10307	O
162	10308	O
163	10308	O
164	10309	X
165	10309	X
166	10309	O
167	10309	X
168	10309	O
169	10310	O
170	10310	O
171	10311	O
172	10311	O
173	10312	O
174	10312	X
175	10312	X
176	10312	O
177	10313	X
178	10314	X
179	10314	X
180	10314	X
181	10315	X
182	10315	X
183	10316	O
184	10316	X
185	10317	X
186	10318	X
187	10318	O
188	10319	O
189	10319	X
190	10319	X
191	10320	X
192	10321	O
193	10322	X
194	10323	O
195	10323	O
196	10323	O
197	10324	X
198	10324	X
199	10324	X
200	10324	X
201	10324	X
202	10325	O
203	10325	X
204	10325	O
205	10325	O
206	10325	X
207	10326	X
208	10326	X
209	10326	X
210	10327	X
211	10327	X
212	10327	X
213	10327	X
214	10328	O
215	10328	X
216	10328	O
217	10329	O
218	10329	O
219	10329	X
220	10329	X
221	10330	X
222	10330	X
223	10331	X
224	10332	X
225	10332	O
226	10332	X
227	10333	O
228	10333	O
229	10333	X
230	10334	O
231	10334	O
232	10335	O
233	10335	X
234	10335	O
235	10335	X
236	10336	X
237	10337	X
238	10337	X
239	10337	X
240	10337	X
241	10337	X
242	10338	X
243	10338	X
244	10339	O
245	10339	X
246	10339	X
247	10340	X
248	10340	X
249	10340	X
250	10341	O
251	10341	O
252	10342	X
253	10342	X
254	10342	X
255	10342	X
256	10343	X
257	10343	O
258	10343	X
259	10344	X
260	10344	X
261	10345	X
262	10345	X
263	10345	O
264	10346	X
265	10346	X
266	10347	O
267	10347	X
268	10347	O
269	10347	O
270	10348	X
271	10348	X
272	10349	X
273	10350	X
274	10350	X
275	10351	X
276	10351	X
277	10351	X
278	10351	O
279	10352	O
280	10352	X
281	10353	X
282	10353	X
283	10354	X
284	10354	O
285	10355	X
286	10355	X
287	10356	X
288	10356	X
289	10356	X
290	10357	X
291	10357	X
292	10357	O
293	10358	O
294	10358	O
295	10358	X
296	10359	X
297	10359	X
298	10359	X
299	10360	X
300	10360	X
301	10360	O
302	10360	X
303	10360	X
304	10361	X
305	10361	X
306	10362	X
307	10362	X
308	10362	X
309	10363	X
310	10363	X
311	10363	X
312	10364	X
313	10364	O
314	10365	X
315	10366	O
316	10366	O
317	10367	X
318	10367	X
319	10367	X
320	10367	O
321	10368	O
322	10368	X
323	10368	X
324	10368	X
325	10369	X
326	10369	X
327	10370	X
328	10370	X
329	10370	X
330	10371	O
331	10372	X
332	10372	X
333	10372	X
334	10372	X
335	10373	X
336	10373	X
337	10374	X
338	10374	X
339	10375	X
340	10375	O
341	10376	X
342	10377	X
343	10377	X
344	10378	O
345	10379	O
346	10379	X
347	10379	X
348	10380	X
349	10380	X
350	10380	O
351	10380	X
352	10381	X
353	10382	X
354	10382	O
355	10382	X
356	10382	X
357	10382	X
358	10383	X
359	10383	X
360	10383	X
361	10384	X
362	10384	X
363	10385	O
364	10385	X
365	10385	O
366	10386	X
367	10386	O
368	10387	X
369	10387	O
370	10387	X
371	10387	X
372	10388	X
373	10388	X
374	10388	X
375	10389	X
376	10389	X
377	10389	X
378	10389	X
379	10390	X
380	10390	X
381	10390	X
382	10390	X
383	10391	X
384	10392	X
385	10393	X
386	10393	X
387	10393	O
388	10393	X
389	10393	X
390	10394	O
391	10394	O
392	10395	X
393	10395	X
394	10395	O
395	10396	X
396	10396	X
397	10396	X
398	10397	O
399	10397	X
400	10398	X
401	10398	X
402	10399	X
403	10399	X
404	10399	X
405	10399	X
406	10400	X
407	10400	X
408	10400	X
409	10401	X
410	10401	X
411	10401	X
412	10401	X
413	10402	X
414	10402	X
415	10403	X
416	10403	X
417	10404	X
418	10404	X
419	10404	X
420	10405	X
421	10406	O
422	10406	X
423	10406	X
424	10406	O
425	10406	O
426	10407	X
427	10407	X
428	10407	X
429	10408	O
430	10408	O
431	10408	X
432	10409	X
433	10409	X
434	10410	X
435	10410	X
436	10411	X
437	10411	X
438	10411	O
439	10412	X
440	10413	X
441	10413	X
442	10413	X
443	10414	X
444	10414	X
445	10415	O
446	10415	X
447	10416	X
448	10416	O
449	10416	X
450	10417	X
451	10417	O
452	10417	X
453	10417	X
454	10418	X
455	10418	X
456	10418	X
457	10418	X
458	10419	X
459	10419	X
460	10420	X
461	10420	O
462	10420	O
463	10420	X
464	10421	O
465	10421	X
466	10421	X
467	10421	O
468	10422	O
469	10423	X
470	10423	X
471	10424	X
472	10424	X
473	10424	X
474	10425	O
475	10425	X
476	10426	O
477	10426	O
478	10427	X
479	10428	X
480	10429	X
481	10429	X
482	10430	X
483	10430	X
484	10430	X
485	10430	X
486	10431	X
487	10431	X
488	10431	X
489	10432	O
490	10432	X
491	10433	X
492	10434	O
493	10434	X
494	10435	O
495	10435	X
496	10435	O
497	10436	O
498	10436	X
499	10436	X
500	10436	X
501	10437	X
502	10438	X
503	10438	X
504	10438	X
505	10439	X
506	10439	X
507	10439	O
508	10439	X
509	10440	X
510	10440	X
511	10440	X
512	10440	X
513	10441	X
514	10442	X
515	10442	X
516	10442	X
517	10443	O
518	10443	X
519	10444	O
520	10444	X
521	10444	O
522	10444	X
523	10445	O
524	10445	X
525	10446	X
526	10446	X
527	10446	O
528	10446	X
529	10447	X
530	10447	X
531	10447	O
532	10448	O
533	10448	X
534	10449	X
535	10449	X
536	10449	X
537	10450	X
538	10450	O
539	10451	X
540	10451	X
541	10451	X
542	10451	X
543	10452	X
544	10452	X
545	10453	X
546	10453	X
547	10454	X
548	10454	X
549	10454	O
550	10455	X
551	10455	X
552	10455	X
553	10455	X
554	10456	X
555	10456	X
556	10457	X
557	10458	X
558	10458	X
559	10458	X
560	10458	X
561	10458	X
562	10459	X
563	10459	X
564	10459	X
565	10460	X
566	10460	O
567	10461	X
568	10461	X
569	10461	X
570	10462	O
571	10462	X
572	10463	X
573	10463	X
574	10464	X
575	10464	O
576	10464	X
577	10464	X
578	10465	X
579	10465	X
580	10465	X
581	10465	X
582	10465	X
583	10466	O
584	10466	O
585	10467	X
586	10467	X
587	10468	O
588	10468	X
589	10469	X
590	10469	X
591	10469	O
592	10470	X
593	10470	X
594	10470	O
595	10471	X
596	10471	X
597	10472	X
598	10472	X
599	10473	X
600	10473	X
601	10474	X
602	10474	X
603	10474	X
604	10474	O
605	10475	X
606	10475	X
607	10475	X
608	10476	O
609	10476	X
610	10477	X
611	10477	X
612	10477	X
613	10478	X
614	10479	X
615	10479	X
616	10479	X
617	10479	X
618	10480	X
619	10480	X
620	10481	X
621	10481	X
622	10482	O
623	10483	X
624	10483	X
625	10484	X
626	10484	O
627	10484	O
628	10485	X
629	10485	X
630	10485	X
631	10485	X
632	10486	O
633	10486	X
634	10486	X
635	10487	O
636	10487	X
637	10487	X
638	10488	X
639	10488	X
640	10489	X
641	10489	X
642	10490	X
643	10490	X
644	10490	X
645	10491	X
646	10491	O
647	10492	X
648	10492	X
649	10493	X
650	10493	O
651	10493	O
652	10494	X
653	10495	O
654	10495	X
655	10495	O
656	10496	X
657	10497	X
658	10497	X
659	10497	X
660	10498	X
661	10498	O
662	10498	X
663	10499	X
664	10499	X
665	10500	X
666	10500	O
667	10501	X
668	10502	X
669	10502	O
670	10502	X
671	10503	X
672	10503	X
673	10504	X
674	10504	X
675	10504	O
676	10504	X
677	10505	O
678	10506	X
679	10506	X
680	10507	X
681	10507	X
682	10508	O
683	10508	O
684	10509	O
685	10510	X
686	10510	X
687	10511	X
688	10511	X
689	10511	O
690	10512	O
691	10512	O
692	10512	O
693	10512	X
694	10513	X
695	10513	X
696	10513	X
697	10514	X
698	10514	X
699	10514	X
700	10514	X
701	10514	X
702	10515	X
703	10515	X
704	10515	X
705	10515	X
706	10515	X
707	10516	X
708	10516	X
709	10516	X
710	10517	O
711	10517	O
712	10517	O
713	10518	O
714	10518	X
715	10518	O
716	10519	X
717	10519	X
718	10519	O
719	10520	O
720	10520	O
721	10521	O
722	10521	O
723	10521	O
724	10522	X
725	10522	X
726	10522	X
727	10522	X
728	10523	X
729	10523	X
730	10523	X
731	10523	O
732	10524	O
733	10524	O
734	10524	X
735	10524	X
736	10525	X
737	10525	X
738	10526	O
739	10526	O
740	10526	X
741	10527	X
742	10527	X
743	10528	O
744	10528	O
745	10528	O
746	10529	X
747	10529	X
748	10529	O
749	10530	X
750	10530	X
751	10530	X
752	10530	X
753	10531	O
754	10532	X
755	10532	X
756	10533	X
757	10533	X
758	10533	X
759	10534	O
760	10534	O
761	10534	O
762	10535	X
763	10535	O
764	10535	O
765	10535	X
766	10536	X
767	10536	X
768	10536	X
769	10536	X
770	10537	X
771	10537	O
772	10537	X
773	10537	X
774	10537	O
775	10538	O
776	10538	O
777	10539	O
778	10539	X
779	10539	X
780	10539	O
781	10540	X
782	10540	X
783	10540	X
784	10540	X
785	10541	X
786	10541	O
787	10541	X
788	10541	O
789	10542	X
790	10542	X
791	10543	X
792	10543	X
793	10544	O
794	10544	O
795	10545	O
796	10546	O
797	10546	X
798	10546	X
799	10547	X
800	10547	X
801	10548	O
802	10548	X
803	10549	X
804	10549	X
805	10549	X
806	10550	O
807	10550	O
808	10550	O
809	10550	O
810	10551	X
811	10551	X
812	10551	X
813	10552	X
814	10552	X
815	10553	X
816	10553	X
817	10553	X
818	10553	X
819	10553	O
820	10554	X
821	10554	X
822	10554	X
823	10554	O
824	10555	X
825	10555	X
826	10555	X
827	10555	X
828	10555	X
829	10556	X
830	10557	X
831	10557	X
832	10558	X
833	10558	X
834	10558	X
835	10558	X
836	10558	O
837	10559	X
838	10559	X
839	10560	X
840	10560	X
841	10561	O
842	10561	X
843	10562	X
844	10562	O
845	10563	X
846	10563	X
847	10564	X
848	10564	O
849	10564	X
850	10565	X
851	10565	X
852	10566	X
853	10566	X
854	10566	O
855	10567	X
856	10567	O
857	10567	X
858	10568	O
859	10569	X
860	10569	X
861	10570	X
862	10570	X
863	10571	X
864	10571	X
865	10572	X
866	10572	O
867	10572	X
868	10572	X
869	10573	X
870	10573	X
871	10573	X
872	10574	X
873	10574	O
874	10574	O
875	10574	O
876	10575	X
877	10575	O
878	10575	X
879	10575	O
880	10576	O
881	10576	X
882	10576	X
883	10577	O
884	10577	X
885	10577	X
886	10578	X
887	10578	O
888	10579	O
889	10579	X
890	10580	X
891	10580	O
892	10580	X
893	10581	X
894	10582	O
895	10582	X
896	10583	O
897	10583	X
898	10583	O
899	10584	X
900	10585	X
901	10586	O
902	10587	O
903	10587	X
904	10587	X
905	10588	X
906	10588	X
907	10589	O
908	10590	X
909	10590	X
910	10591	X
911	10591	O
912	10591	X
913	10592	X
914	10592	O
915	10593	X
916	10593	X
917	10593	O
918	10594	X
919	10594	X
920	10595	X
921	10595	X
922	10595	X
923	10596	O
924	10596	X
925	10596	X
926	10597	X
927	10597	X
928	10597	X
929	10598	X
930	10598	O
931	10599	O
932	10600	O
933	10600	X
934	10601	X
935	10601	X
936	10602	O
937	10603	X
938	10603	X
939	10604	O
940	10604	O
941	10605	X
942	10605	X
943	10605	X
944	10605	X
945	10606	X
946	10606	X
947	10606	O
948	10607	X
949	10607	X
950	10607	X
951	10607	X
952	10607	X
953	10608	X
954	10609	O
955	10609	O
956	10609	O
957	10610	X
958	10611	O
959	10611	O
960	10611	X
961	10612	X
962	10612	X
963	10612	X
964	10612	X
965	10612	X
966	10613	O
967	10613	X
968	10614	X
969	10614	O
970	10614	O
971	10615	O
972	10616	X
973	10616	X
974	10616	X
975	10616	X
976	10617	X
977	10618	X
978	10618	X
979	10618	X
980	10619	X
981	10619	X
982	10620	O
983	10620	O
984	10621	O
985	10621	O
986	10621	X
987	10621	X
988	10622	X
989	10622	X
990	10623	X
991	10623	X
992	10623	X
993	10623	O
994	10623	X
995	10624	O
996	10624	O
997	10624	O
998	10625	O
999	10625	O
1000	10625	O
1001	10626	X
1002	10626	X
1003	10626	X
1004	10627	X
1005	10627	X
1006	10628	X
1007	10629	X
1008	10629	O
1009	10630	X
1010	10630	X
1011	10631	O
1012	10632	X
1013	10632	X
1014	10633	X
1015	10633	X
1016	10633	X
1017	10633	X
1018	10634	X
1019	10634	X
1020	10634	X
1021	10634	O
1022	10635	O
1023	10635	X
1024	10635	X
1025	10636	X
1026	10636	O
1027	10637	O
1028	10637	X
1029	10637	X
1030	10638	X
1031	10638	X
1032	10638	X
1033	10639	O
1034	10640	X
1035	10640	X
1036	10641	X
1037	10641	X
1038	10642	X
1039	10642	X
1040	10643	X
1041	10643	X
1042	10643	O
1043	10644	O
1044	10644	X
1045	10644	X
1046	10645	X
1047	10645	X
1048	10646	X
1049	10646	X
1050	10646	X
1051	10646	X
1052	10647	X
1053	10647	X
1054	10648	X
1055	10648	X
1056	10649	X
1057	10649	X
1058	10650	X
1059	10650	X
1060	10650	X
1061	10651	X
1062	10651	X
1063	10652	O
1064	10652	X
1065	10653	X
1066	10653	X
1067	10654	X
1068	10654	X
1069	10654	O
1070	10655	X
1071	10656	O
1072	10656	X
1073	10656	O
1074	10657	X
1075	10657	X
1076	10657	X
1077	10657	O
1078	10657	X
1079	10657	X
1080	10658	X
1081	10658	X
1082	10658	X
1083	10658	X
1084	10659	X
1085	10659	X
1086	10659	X
1087	10660	X
1088	10661	O
1089	10661	X
1090	10662	O
1091	10663	X
1092	10663	X
1093	10663	X
1094	10664	X
1095	10664	X
1096	10664	X
1097	10665	X
1098	10665	O
1099	10665	O
1100	10666	X
1101	10666	O
1102	10667	X
1103	10667	X
1104	10668	O
1105	10668	O
1106	10668	X
1107	10669	X
1108	10670	X
1109	10670	X
1110	10670	X
1111	10670	X
1112	10670	X
1113	10671	O
1114	10671	O
1115	10671	X
1116	10672	X
1117	10672	X
1118	10673	O
1119	10673	O
1120	10673	O
1121	10674	O
1122	10675	X
1123	10675	O
1124	10675	X
1125	10676	O
1126	10676	O
1127	10676	X
1128	10677	X
1129	10677	O
1130	10678	X
1131	10678	X
1132	10678	X
1133	10678	X
1134	10679	X
1135	10680	X
1136	10680	X
1137	10680	X
1138	10681	X
1139	10681	X
1140	10681	X
1141	10682	X
1142	10682	O
1143	10682	X
1144	10683	O
1145	10684	X
1146	10684	X
1147	10684	X
1148	10685	X
1149	10685	O
1150	10685	X
1151	10686	X
1152	10686	X
1153	10687	X
1154	10687	O
1155	10687	O
1156	10688	X
1157	10688	X
1158	10688	X
1159	10689	X
1160	10690	X
1161	10690	X
1162	10691	X
1163	10691	X
1164	10691	X
1165	10691	X
1166	10691	X
1167	10692	X
1168	10693	O
1169	10693	X
1170	10693	X
1171	10693	X
1172	10694	X
1173	10694	X
1174	10694	X
1175	10695	O
1176	10695	O
1177	10695	X
1178	10696	X
1179	10696	X
1180	10697	O
1181	10697	O
1182	10697	X
1183	10697	X
1184	10698	X
1185	10698	O
1186	10698	X
1187	10698	X
1188	10698	O
1189	10699	X
1190	10700	O
1191	10700	X
1192	10700	X
1193	10700	X
1194	10701	X
1195	10701	X
1196	10701	X
1197	10702	O
1198	10702	X
1199	10703	O
1200	10703	X
1201	10703	X
1202	10704	O
1203	10704	X
1204	10704	X
1205	10705	X
1206	10705	O
1207	10706	X
1208	10706	X
1209	10706	O
1210	10707	X
1211	10707	X
1212	10707	X
1213	10708	O
1214	10708	O
1215	10709	X
1216	10709	X
1217	10709	O
1218	10710	O
1219	10710	O
1220	10711	X
1221	10711	X
1222	10711	X
1223	10712	O
1224	10712	X
1225	10713	X
1226	10713	X
1227	10713	X
1228	10713	X
1229	10714	X
1230	10714	X
1231	10714	X
1232	10714	X
1233	10714	X
1234	10715	X
1235	10715	X
1236	10716	O
1237	10716	O
1238	10716	O
1239	10717	X
1240	10717	X
1241	10717	X
1242	10718	X
1243	10718	X
1244	10718	X
1245	10718	X
1246	10719	X
1247	10719	O
1248	10719	X
1249	10720	X
1250	10720	O
1251	10721	X
1252	10722	O
1253	10722	X
1254	10722	X
1255	10722	X
1256	10723	X
1257	10724	X
1258	10724	O
1259	10725	X
1260	10725	O
1261	10725	O
1262	10726	X
1263	10726	O
1264	10727	X
1265	10727	O
1266	10727	O
1267	10728	X
1268	10728	O
1269	10728	X
1270	10728	X
1271	10729	X
1272	10729	X
1273	10729	X
1274	10730	X
1275	10730	O
1276	10730	O
1277	10731	X
1278	10731	X
1279	10732	X
1280	10733	X
1281	10733	X
1282	10733	X
1283	10734	X
1284	10734	X
1285	10734	X
1286	10735	X
1287	10735	O
1288	10736	X
1289	10736	X
1290	10737	O
1291	10737	X
1292	10738	O
1293	10739	O
1294	10739	X
1295	10740	O
1296	10740	X
1297	10740	X
1298	10740	X
1299	10741	X
1300	10742	X
1301	10742	X
1302	10742	X
1303	10743	X
1304	10744	X
1305	10745	X
1306	10745	X
1307	10745	X
1308	10745	O
1309	10746	O
1310	10746	X
1311	10746	O
1312	10746	X
1313	10747	O
1314	10747	X
1315	10747	O
1316	10747	X
1317	10748	X
1318	10748	X
1319	10748	X
1320	10749	X
1321	10749	O
1322	10749	O
1323	10750	O
1324	10750	X
1325	10750	X
1326	10751	X
1327	10751	X
1328	10751	X
1329	10751	X
1330	10752	O
1331	10752	O
1332	10753	O
1333	10753	O
1334	10754	O
1335	10755	X
1336	10755	X
1337	10755	X
1338	10755	X
1339	10756	X
1340	10756	X
1341	10756	O
1342	10756	X
1343	10757	X
1344	10757	O
1345	10757	X
1346	10757	X
1347	10758	X
1348	10758	X
1349	10758	X
1350	10759	O
1351	10760	X
1352	10760	X
1353	10760	X
1354	10761	X
1355	10761	X
1356	10762	X
1357	10762	X
1358	10762	X
1359	10762	X
1360	10763	X
1361	10763	O
1362	10763	X
1363	10764	X
1364	10764	X
1365	10765	X
1366	10766	X
1367	10766	X
1368	10766	X
1369	10767	O
1370	10768	O
1371	10768	X
1372	10768	X
1373	10768	X
1374	10769	X
1375	10769	X
1376	10769	X
1377	10769	X
1378	10770	X
1379	10771	X
1380	10772	X
1381	10772	X
1382	10773	X
1383	10773	X
1384	10773	O
1385	10774	O
1386	10774	X
1387	10775	O
1388	10775	O
1389	10776	X
1390	10776	X
1391	10776	X
1392	10776	X
1393	10777	X
1394	10778	O
1395	10779	X
1396	10779	X
1397	10780	X
1398	10780	X
1399	10781	O
1400	10781	X
1401	10781	X
1402	10782	O
1403	10783	O
1404	10783	O
1405	10784	X
1406	10784	O
1407	10784	X
1408	10785	O
1409	10785	O
1410	10786	X
1411	10786	X
1412	10786	X
1413	10787	X
1414	10787	X
1415	10788	X
1416	10788	X
1417	10789	X
1418	10789	X
1419	10789	X
1420	10789	X
1421	10790	O
1422	10790	X
1423	10791	X
1424	10791	X
1425	10792	O
1426	10792	O
1427	10792	X
1428	10793	X
1429	10793	O
1430	10794	X
1431	10794	O
1432	10795	X
1433	10795	X
1434	10796	X
1435	10796	O
1436	10796	X
1437	10796	X
1438	10797	X
1439	10798	O
1440	10798	O
1441	10799	X
1442	10799	X
1443	10799	X
1444	10800	X
1445	10800	O
1446	10800	O
1447	10801	X
1448	10801	X
1449	10802	X
1450	10802	X
1451	10802	X
1452	10802	O
1453	10803	X
1454	10803	X
1455	10803	X
1456	10804	X
1457	10804	X
1458	10804	O
1459	10805	O
1460	10805	O
1461	10806	X
1462	10806	O
1463	10806	X
1464	10807	O
1465	10808	X
1466	10808	X
1467	10809	X
1468	10810	O
1469	10810	O
1470	10810	O
1471	10811	X
1472	10811	X
1473	10811	X
1474	10812	X
1475	10812	X
1476	10812	X
1477	10813	X
1478	10813	X
1479	10814	X
1480	10814	X
1481	10814	O
1482	10814	X
1483	10815	X
1484	10816	X
1485	10816	X
1486	10817	X
1487	10817	X
1488	10817	X
1489	10817	X
1490	10818	X
1491	10818	X
1492	10819	O
1493	10819	X
1494	10820	X
1495	10821	X
1496	10821	O
1497	10822	O
1498	10822	O
1499	10823	X
1500	10823	X
1501	10823	X
1502	10823	X
1503	10824	X
1504	10824	O
1505	10825	X
1506	10825	X
1507	10826	X
1508	10826	X
1509	10827	X
1510	10827	X
1511	10828	O
1512	10828	O
1513	10829	O
1514	10829	X
1515	10829	O
1516	10829	X
1517	10830	O
1518	10830	X
1519	10830	X
1520	10830	X
1521	10831	O
1522	10831	O
1523	10831	O
1524	10831	O
1525	10832	O
1526	10832	O
1527	10832	X
1528	10832	O
1529	10833	X
1530	10833	O
1531	10833	O
1532	10834	O
1533	10834	X
1534	10835	X
1535	10835	O
1536	10836	X
1537	10836	O
1538	10836	X
1539	10836	X
1540	10836	X
1541	10837	O
1542	10837	X
1543	10837	X
1544	10837	X
1545	10838	O
1546	10838	X
1547	10838	X
1548	10839	X
1549	10839	X
1550	10840	O
1551	10840	O
1552	10841	X
1553	10841	X
1554	10841	X
1555	10841	X
1556	10842	X
1557	10842	O
1558	10842	X
1559	10842	X
1560	10843	O
1561	10844	X
1562	10845	X
1563	10845	X
1564	10845	X
1565	10845	X
1566	10845	X
1567	10846	X
1568	10846	X
1569	10846	X
1570	10847	X
1571	10847	X
1572	10847	X
1573	10847	X
1574	10847	X
1575	10847	X
1576	10848	X
1577	10848	O
1578	10849	X
1579	10849	X
1580	10850	X
1581	10850	O
1582	10850	X
1583	10851	O
1584	10851	O
1585	10851	O
1586	10851	X
1587	10852	X
1588	10852	O
1589	10852	X
1590	10853	O
1591	10854	X
1592	10854	X
1593	10855	X
1594	10855	X
1595	10855	X
1596	10855	X
1597	10856	X
1598	10856	X
1599	10857	X
1600	10857	X
1601	10857	O
1602	10858	O
1603	10858	O
1604	10858	O
1605	10859	X
1606	10859	X
1607	10859	X
1608	10860	O
1609	10860	X
1610	10861	X
1611	10861	X
1612	10861	X
1613	10861	X
1614	10861	O
1615	10862	X
1616	10862	O
1617	10863	X
1618	10863	X
1619	10864	O
1620	10864	X
1621	10865	X
1622	10865	X
1623	10866	X
1624	10866	O
1625	10866	X
1626	10867	O
1627	10868	X
1628	10868	X
1629	10868	X
1630	10869	X
1631	10869	O
1632	10869	X
1633	10869	X
1634	10870	O
1635	10870	O
1636	10871	X
1637	10871	X
1638	10871	X
1639	10872	O
1640	10872	X
1641	10872	X
1642	10872	X
1643	10873	X
1644	10873	O
1645	10874	O
1646	10875	X
1647	10875	X
1648	10875	X
1649	10876	X
1650	10876	X
1651	10877	X
1652	10877	X
1653	10878	X
1654	10879	X
1655	10879	O
1656	10879	O
1657	10880	X
1658	10880	X
1659	10880	X
1660	10881	O
1661	10882	X
1662	10882	X
1663	10882	X
1664	10883	O
1665	10884	X
1666	10884	X
1667	10884	X
1668	10885	X
1669	10885	X
1670	10885	X
1671	10885	X
1672	10886	X
1673	10886	X
1674	10886	X
1675	10887	O
1676	10888	X
1677	10888	X
1678	10889	X
1679	10889	X
1680	10890	X
1681	10890	O
1682	10890	X
1683	10891	X
1684	10892	X
1685	10893	X
1686	10893	O
1687	10893	X
1688	10893	X
1689	10893	X
1690	10894	X
1691	10894	X
1692	10894	X
1693	10895	X
1694	10895	X
1695	10895	X
1696	10895	X
1697	10896	X
1698	10896	X
1699	10897	X
1700	10897	X
1701	10898	O
1702	10899	O
1703	10900	O
1704	10901	X
1705	10901	X
1706	10902	X
1707	10902	O
1708	10903	X
1709	10903	X
1710	10903	X
1711	10904	X
1712	10904	X
1713	10905	X
1714	10906	X
1715	10907	X
1716	10908	X
1717	10908	X
1718	10909	X
1719	10909	X
1720	10909	O
1721	10910	X
1722	10910	O
1723	10910	O
1724	10911	O
1725	10911	X
1726	10911	X
1727	10912	X
1728	10912	X
1729	10913	X
1730	10913	X
1731	10913	X
1732	10914	X
1733	10915	O
1734	10915	X
1735	10915	O
1736	10916	O
1737	10916	O
1738	10916	X
1739	10917	O
1740	10917	O
1741	10918	X
1742	10918	X
1743	10919	X
1744	10919	X
1745	10919	X
1746	10920	X
1747	10921	O
1748	10921	X
1749	10922	X
1750	10922	X
1751	10923	O
1752	10923	O
1753	10923	X
1754	10924	X
1755	10924	X
1756	10924	O
1757	10925	X
1758	10925	X
1759	10926	O
1760	10926	O
1761	10926	O
1762	10926	O
1763	10927	O
1764	10927	O
1765	10927	X
1766	10928	O
1767	10928	O
1768	10929	X
1769	10929	X
1770	10929	X
1771	10930	X
1772	10930	X
1773	10930	X
1774	10930	X
1775	10931	X
1776	10931	X
1777	10932	X
1778	10932	X
1779	10932	X
1780	10932	X
1781	10933	O
1782	10933	X
1783	10934	X
1784	10935	X
1785	10935	O
1786	10935	O
1787	10936	X
1788	10937	O
1789	10937	X
1790	10938	X
1791	10938	X
1792	10938	X
1793	10938	X
1794	10939	O
1795	10939	X
1796	10940	O
1797	10940	X
1798	10941	X
1799	10941	X
1800	10941	X
1801	10941	X
1802	10942	X
1803	10943	X
1804	10943	X
1805	10943	X
1806	10944	O
1807	10944	X
1808	10944	X
1809	10945	X
1810	10945	O
1811	10946	X
1812	10946	X
1813	10946	X
1814	10947	O
1815	10948	O
1816	10948	X
1817	10948	O
1818	10949	X
1819	10949	X
1820	10949	O
1821	10949	X
1822	10950	O
1823	10951	X
1824	10951	O
1825	10951	X
1826	10952	X
1827	10952	O
1828	10953	X
1829	10953	X
1830	10954	X
1831	10954	X
1832	10954	X
1833	10954	X
1834	10955	X
1835	10956	X
1836	10956	X
1837	10956	O
1838	10957	X
1839	10957	X
1840	10957	O
1841	10958	X
1842	10958	O
1843	10958	O
1844	10959	X
1845	10960	O
1846	10960	X
1847	10961	O
1848	10961	X
1849	10962	X
1850	10962	X
1851	10962	X
1852	10962	O
1853	10962	X
1854	10963	O
1855	10964	O
1856	10964	O
1857	10964	O
1858	10965	X
1859	10966	O
1860	10966	X
1861	10966	X
1862	10967	X
1863	10967	X
1864	10968	X
1865	10968	X
1866	10968	O
1867	10969	O
1868	10970	X
1869	10971	X
1870	10972	O
1871	10972	O
1872	10973	O
1873	10973	O
1874	10973	O
1875	10974	O
1876	10975	X
1877	10975	O
1878	10976	X
1879	10977	X
1880	10977	X
1881	10977	O
1882	10977	X
1883	10978	X
1884	10978	X
1885	10978	O
1886	10978	O
1887	10979	X
1888	10979	X
1889	10979	X
1890	10979	X
1891	10979	X
1892	10979	X
1893	10980	X
1894	10981	X
1895	10982	X
1896	10982	O
1897	10983	X
1898	10983	X
1899	10984	X
1900	10984	X
1901	10984	X
1902	10985	X
1903	10985	O
1904	10985	X
1905	10986	X
1906	10986	X
1907	10986	O
1908	10986	X
1909	10987	X
1910	10987	O
1911	10987	X
1912	10988	X
1913	10988	X
1914	10989	X
1915	10989	X
1916	10989	O
1917	10990	X
1918	10990	X
1919	10990	X
1920	10990	X
1921	10991	X
1922	10991	X
1923	10991	X
1924	10992	O
1925	10993	X
1926	10993	X
1927	10994	X
1928	10995	X
1929	10995	O
1930	10996	X
1931	10997	X
1932	10997	X
1933	10997	X
1934	10998	X
1935	10998	O
1936	10998	X
1937	10998	X
1938	10999	X
1939	10999	X
1940	10999	X
1941	11000	X
1942	11000	X
1943	11000	X
1944	11001	X
1945	11001	X
1946	11001	X
1947	11001	O
1948	11002	X
1949	11002	X
1950	11002	X
1951	11002	X
1952	11003	O
1953	11003	O
1954	11003	O
1955	11004	O
1956	11004	O
1957	11005	O
1958	11005	O
1959	11006	O
1960	11006	O
1961	11007	X
1962	11007	O
1963	11007	X
1964	11008	X
1965	11008	X
1966	11008	X
1967	11009	X
1968	11009	X
1969	11009	O
1970	11010	X
1971	11010	O
1972	11011	X
1973	11011	X
1974	11012	X
1975	11012	X
1976	11012	X
1977	11013	O
1978	11013	O
1979	11013	X
1980	11013	O
1981	11014	X
1982	11015	X
1983	11015	X
1984	11016	X
1985	11016	X
1986	11017	X
1987	11017	X
1988	11017	X
1989	11018	X
1990	11018	O
1991	11018	O
1992	11019	O
1993	11019	O
1994	11020	X
1995	11021	X
1996	11021	X
1997	11021	X
1998	11021	X
1999	11021	X
2000	11022	X
2001	11022	X
2002	11023	O
2003	11023	X
2004	11024	X
2005	11024	X
2006	11024	X
2007	11024	X
2008	11025	O
2009	11025	X
2010	11026	O
2011	11026	O
2012	11027	X
2013	11027	X
2014	11028	X
2015	11028	X
2016	11029	X
2017	11029	X
2018	11030	X
2019	11030	X
2020	11030	X
2021	11030	X
2022	11031	X
2023	11031	X
2024	11031	X
2025	11031	X
2026	11031	X
2027	11032	X
2028	11032	X
2029	11032	X
2030	11033	X
2031	11033	X
2032	11034	X
2033	11034	X
2034	11034	O
2035	11035	O
2036	11035	X
2037	11035	X
2038	11035	O
2039	11036	O
2040	11036	X
2041	11037	O
2042	11038	O
2043	11038	O
2044	11038	X
2045	11039	X
2046	11039	X
2047	11039	X
2048	11039	X
2049	11040	X
2050	11041	X
2051	11041	X
2052	11042	X
2053	11042	O
2054	11043	O
2055	11044	X
2056	11045	X
2057	11045	X
2058	11046	X
2059	11046	X
2060	11046	X
2061	11047	X
2062	11047	X
2063	11048	X
2064	11049	O
2065	11049	O
2066	11050	X
2067	11051	O
2068	11052	X
2069	11052	O
2070	11053	X
2071	11053	X
2072	11053	X
2073	11054	O
2074	11054	X
2075	11055	X
2076	11055	X
2077	11055	X
2078	11055	X
2079	11056	X
2080	11056	X
2081	11056	X
2082	11057	O
2083	11058	O
2084	11058	X
2085	11058	O
2086	11059	X
2087	11059	X
2088	11059	X
2089	11060	O
2090	11060	O
2091	11061	X
2092	11062	O
2093	11062	X
2094	11063	X
2095	11063	X
2096	11063	X
2097	11064	X
2098	11064	X
2099	11064	X
2100	11064	O
2101	11064	X
2102	11065	O
2103	11065	X
2104	11066	O
2105	11066	X
2106	11066	X
2107	11067	O
2108	11068	O
2109	11068	X
2110	11068	X
2111	11069	X
2112	11070	X
2113	11070	X
2114	11070	X
2115	11070	X
2116	11071	X
2117	11071	O
2118	11072	O
2119	11072	X
2120	11072	X
2121	11072	X
2122	11073	O
2123	11073	X
2124	11074	X
2125	11075	O
2126	11075	X
2127	11075	O
2128	11076	X
2129	11076	X
2130	11076	O
2131	11077	X
2132	11077	O
2133	11077	O
2134	11077	O
2135	11077	O
2136	11077	O
2137	11077	O
2138	11077	O
2139	11077	O
2140	11077	O
2141	11077	O
2142	11077	O
2143	11077	O
2144	11077	O
2145	11077	O
2146	11077	O
2147	11077	O
2148	11077	O
2149	11077	O
2150	11077	O
2151	11077	O
2152	11077	O
2153	11077	O
2154	11077	O
2155	11077	O

3. Random usage of CHAR

SQL Server Query 3

            
 SELECT ProductName, REPLICATE(CHAR(42), UnitsInStock / 10) AS StockLevelStars   

 FROM Products   

 WHERE UnitsInStock IS NOT NULL AND UnitsInStock > 0 ORDER BY UnitsInStock DESC;

Create SQL query with SqlQueryBuilder 3

            
 var (sql3, parameters3) = new SqlQueryBuilder()  

     .Select().Column("ProductName", "ProductName")  

     .Column(new REPLICATE(new CHAR(42), new ColumnArithmatic().Column("UnitsInStock").DIVIDE().Value(10)), "StockLevelStars")  

     .From("Products")  

     .Where(new Where(new IS_NOT_NULL(new Column("UnitsInStock"))).AND(new Column("UnitsInStock").GreaterThan(0)))  

     .OrderBy(new OrderBy().SetColumnDescending("UnitsInStock"))  

     .Build();

Query build by SqlQueryBuilder 3

            
SELECT ProductName AS ProductName,
       REPLICATE(CHAR(@pMAIN_2507192103021827020), UnitsInStock / @pMAIN_2507192103021827021) AS StockLevelStars
FROM Products
WHERE UnitsInStock IS NOT NULL
      AND UnitsInStock > @pMAIN_2507192103021827022
ORDER BY UnitsInStock DESC;

Parameters (If used)

Name	Value
@pMAIN_2507192103021827020	42
@pMAIN_2507192103021827021	10
@pMAIN_2507192103021827022	0

Query Results 3:

	ProductName	StockLevelStars
1	Rhönbräu Klosterbier	************
2	Boston Crab Meat	************
3	Grandma's Boysenberry Spread	************
4	Pâté chinois	***********
5	Sirop d'érable	***********
6	Geitost	***********
7	Inlagd Sill	***********
8	Sasquatch Ale	***********
9	Gustaf's Knäckebröd	**********
10	Röd Kaviar	**********
11	Spegesild	*********
12	Queso Manchego La Pastora	********
13	Jack's New England Clam Chowder	********
14	Raclette Courdavault	*******
15	Louisiana Fiery Hot Pepper Sauce	*******
16	NuNuCa Nuß-Nougat-Creme	*******
17	Chartreuse verte	******
18	Valkoinen suklaa	******
19	Escargots de Bourgogne	******
20	Tunnbröd	******
21	Lakkalikööri	*****
22	Chef Anton's Cajun Seasoning	*****
23	Laughing Lumberjack Lager	*****
24	Schoggi Schokolade	****
25	Carnarvon Tigers	****
26	Sir Rodney's Marmalade	****
27	Genen Shouyu	***
28	Chai	***
29	Filo Mix	***
30	Ravioli Angelo	***
31	Zaanse koeken	***
32	Tofu	***
33	Original Frankfurter grüne Soße	***
34	Ikura	***
35	Mishi Kobe Niku	**
36	Pavlova	**
37	Gula Malacca	**
38	Gudbrandsdalsost	**
39	Flotemysost	**
40	Rössle Sauerkraut	**
41	Singaporean Hokkien Fried Mee	**
42	Teatime Chocolate Biscuits	**
43	Konbu	**
44	Vegie-spread	**
45	Wimmers gute Semmelknödel	**
46	Queso Cabrales	**
47	Gnocchi di nonna Alice	**
48	Tourtière	**
49	Manjimup Dried Apples	**
50	Steeleye Stout	**
51	Guaraná Fantástica	**
52	Camembert Pierrot	*
53	Tarte au sucre	*
54	Côte de Blaye	*
55	Ipoh Coffee	*
56	Chang	*
57	Uncle Bob's Organic Dried Pears	*
58	Gumbär Gummibärchen	*
59	Chocolade	*
60	Outback Lager	*
61	Mozzarella di Giovanni	*
62	Aniseed Syrup	*
63	Gravad lax	*
64	Nord-Ost Matjeshering	*
65	Maxilaku	*
66	Mascarpone Fabioli
67	Northwoods Cranberry Sauce
68	Scottish Longbreads
69	Rogede sild
70	Longlife Tofu
71	Louisiana Hot Spiced Okra
72	Sir Rodney's Scones

4. Random usage of CHAR

SQL Server Query 4

            
 SELECT CompanyName, SUBSTRING(CompanyName, 2, 1) AS SecondLetter, ASCII(SUBSTRING(CompanyName, 2, 1)) AS SecondLetterASCII,   

 	CHAR(ASCII(SUBSTRING(CompanyName, 2, 1))) AS SecondLetterCHAR   

 FROM Customers   

 WHERE CustomerID = 'ALFKI';

Create SQL query with SqlQueryBuilder 4

            
 var (sql4, parameters4) = new SqlQueryBuilder()  

     .Select().Column("CompanyName", "CompanyName")  

     .Column(new SUBSTRING(new Column("CompanyName"), 2, 1), "SecondLetter")  

     .Column(new ASCII(new SUBSTRING(new Column("CompanyName"), 2, 1)), "SecondLetterASCII")  

     .Column(new CHAR(new ASCII(new SUBSTRING(new Column("CompanyName"), 2, 1))), "SecondLetterCHAR")  

     .From("Customers")  

     .Where(new Where(new Column("CustomerID").Equale("ALFKI")))  

     .Build();

Query build by SqlQueryBuilder 4

            
SELECT CompanyName AS CompanyName,
       SUBSTRING(CompanyName, @pMAIN_2507192103021872220, @pMAIN_2507192103021872221) AS SecondLetter,
       ASCII(SUBSTRING(CompanyName, @pMAIN_2507192103021872222, @pMAIN_2507192103021872223)) AS SecondLetterASCII,
       CHAR(ASCII(SUBSTRING(CompanyName, @pMAIN_2507192103021872224, @pMAIN_2507192103021872225))) AS SecondLetterCHAR
FROM Customers
WHERE CustomerID = @pMAIN_2507192103021872226;

Parameters (If used)

Name	Value
@pMAIN_2507192103021872220	2
@pMAIN_2507192103021872221	1
@pMAIN_2507192103021872222	2
@pMAIN_2507192103021872223	1
@pMAIN_2507192103021872224	2
@pMAIN_2507192103021872225	1
@pMAIN_2507192103021872226	ALFKI

Query Results 4:

	CompanyName	SecondLetter	SecondLetterASCII	SecondLetterCHAR
1	Alfreds Futterkiste	l	108	l